error in transfer sql task

I am trying to transfer tables from a 2000 database to a 2005 database. I selected only the tables I wanted and when executing the task I get:

Error: 0xC002F363 at Copy Tables, Transfer Sql Server Objects Task: Table "XXX" does not exist at the source.
Task failed: Copy Tables

I have the correct permisions on both (they are both dbo.) and I can create DataFlow tasks for each individual table, however there are about 50-75 tables I need to copy. I tried recreating the package with no luck. Any ideas?

Thanks,
Abe

Try using "Windows Authentication" instead of "SQL Server Authentication" at the destination. I remember seeing a bug (which has been fixed and will be made available in the next SP release).|||I am using windows authentication in the destiantion. I don't have a choice other than using sql authetication at the source though.|||Sorry. The information I gave was not correct.

I did not read your post carefully. I was referring to a different bug related to transfer of objects between two SQL Server 2005 servers.

As far as your problem is concerned, it has been identified as a bug and being handled.

Hopefully the fix will be available soon.

Error in Transfer SQL Server Objects

Hi ,

i am copying objects from one DB to other usign Transfer SQL Server Objects Task. i am getting this error

[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "ERROR : errorCode=-1073548784 description=Executing the query "DROP TABLE [dbo].[testCopy] " failed with the following error: "Cannot drop the table 'dbo.testCopy', because it does not exist or you do not have permission.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}".

it is true that object doesnt exist on the destination. but i want it to see if the object is there then drop otherwise just copy the object there,

Regards,

Haroon

This should not happen post SQL 2005 SP1, can you confirm your version?sql

Error in Transfer SQL Server Object Task

Hi all,

I am facing problem while using Transfer SQL Server Object Task in SSIS, it is not importing table & its attributes.

The details settings of Transfer SQL Server Object Task as follows:
clicking edit - Objects(left pane)
Right pane
Connection
Source Connection existing server name 1
Source Database ganny1
Destination Connection existing server name 1
Destination Database ganny2
Destination copy objects
Objects to copy - copy all tables - true
Table Objects
CopyPrimaryKeys - True
CopyForiegnKeys - True

After setting all this configurations, Executing task, I am not able to get table in my destination database.
Please suggest me to solve the issue.

Thanks in advance
Karna

What is the value of CopySchema? If it's false, trying setting it to true.

error in Reports transfer from access to sql server

Hey,
I Hv been given with upsized adp and mdb. But Reports are not working...
So what could be the problem...
and how culd i solve it.
thxummmm...could you supply just a little more detail?

my usb esp port is clogged|||Sure,,
What i hv been given with are adp and mdb databases...
Now there are some bugs in the adp which wizards do not fixes automatically. So those bugs have to fix by us manually.
The first bug i found is that there is the problem in the reports. The reports after upsizing into sql server are not accessing the data from sql server...
It seems to me that these reports are not connected to sql server some how but application is running good...
I think it may need to change some code but i m unsure that which code...
So plz help..
thx|||Are you getting an error?

What's the data source?

Did all of the tables get qualified with dbo_ in front of them

What do you mean the application is runniong "good"

Can you write a new report and then see what happens?|||When i click on the control in the reports.
It gives me "Invalid Control Propety:Control Source"

and running the application means On the main form i hv some TextBoxes to filled from the database..
and those are good..
but i m having trouble with reports...|||It also says
"No such field in the field list"

Error in OLE DB Command task

Hi all,

After applying the SP2 for Korean - we are getting the following error in the above task.

Transfer Fact Data From StagingDB to Presentation DB: Insert Update MetricFact [1021]: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "'OPTIMIZE' ? ? ?.".

Not sure what the problem is. The same task was running properly before applying the SP2.

For other language SP2 (on other languages) the same task runs correctly and without any error.

sachin.dubey wrote:

Hi all,

After applying the SP2 for Korean - we are getting the following error in the above task.

Transfer Fact Data From StagingDB to Presentation DB: Insert Update MetricFact [1021]: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "'OPTIMIZE' ? ? ?.".

Not sure what the problem is. The same task was running properly before applying the SP2.

For other language SP2 (on other languages) the same task runs correctly and without any error.

Hmmm... strange.

Can you run SQL Server Profiler to see what is getting executed against SQL Server?

-Jamie

|||

I m getting the error at design time also when the Package is opened in BI studio

when i tried using Profiler

it executes exec sp_procedure_params_rowset in backend

and throws following error

???102, ??15, ??1, ????sp_procedure_params_rowset, ?151

'OPTIMIZE' ?????????????.

|||

sachin.dubey wrote:

I m getting the error at design time also when the Package is opened in BI studio

when i tried using Profiler

it executes exec sp_procedure_params_rowset in backend

and throws following error

???102, ??15, ??1, ????sp_procedure_params_rowset, ?151

'OPTIMIZE' ?????????????.

It sounds as though the problem might be outside of SSIS. Try and isolate the problem in SQL Server.

-Jamie

|||

Hmm Thanks Jamie.

I will try there.

Error in OLE DB Command task

Hi all,

After applying the SP2 for Korean - we are getting the following error in the above task.

Transfer Fact Data From StagingDB to Presentation DB: Insert Update MetricFact [1021]: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "'OPTIMIZE' ? ? ?.".

Not sure what the problem is. The same task was running properly before applying the SP2.

For other language SP2 (on other languages) the same task runs correctly and without any error.

sachin.dubey wrote:

Hi all,

After applying the SP2 for Korean - we are getting the following error in the above task.

Transfer Fact Data From StagingDB to Presentation DB: Insert Update MetricFact [1021]: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "'OPTIMIZE' ? ? ?.".

Not sure what the problem is. The same task was running properly before applying the SP2.

For other language SP2 (on other languages) the same task runs correctly and without any error.

Hmmm... strange.

Can you run SQL Server Profiler to see what is getting executed against SQL Server?

-Jamie

|||

I m getting the error at design time also when the Package is opened in BI studio

when i tried using Profiler

it executes exec sp_procedure_params_rowset in backend

and throws following error

???102, ??15, ??1, ????sp_procedure_params_rowset, ?151

'OPTIMIZE' ?????????????.

|||

sachin.dubey wrote:

I m getting the error at design time also when the Package is opened in BI studio

when i tried using Profiler

it executes exec sp_procedure_params_rowset in backend

and throws following error

???102, ??15, ??1, ????sp_procedure_params_rowset, ?151

'OPTIMIZE' ?????????????.

It sounds as though the problem might be outside of SSIS. Try and isolate the problem in SQL Server.

-Jamie

|||

Hmm Thanks Jamie.

I will try there.

Error in File System Task

Hi,

I am trying to transfer all the data from Excel to SQL Server using the Script Task (since I got some issue with the Data Flow -- that is a different story, let us come to this error), and after it got transferred I am deleting the source file using File System Task.

[File System Task] Error: An error occurred with the following error message: "The process cannot access the file 'C:\Prakash\TestFiles\Names.xls' because it is being used by another process."

The problem here is before transfer the data from Excel to SQL Server in the Script Task, the File System Task is getting executed, that is why it says that "it is being used by another process" like that.

I already set the TransactionOption as "Success" only for all the Tasks, but I don't know why the second task is getting executed before the first task completed his job.

If anyone have solution to this, pls let me know in detail ASAP.

Thanks & Regards,

Prakash Srinivasan

Hi All,

Sorry I forgot to close the Excel Connection after the data got transferred. Now I closed it and the problem is solved. But still I have problem with transferring data between Excel and SQL Server using Data Flow Task.

Thanks & Regards,

Prakash Srinivasan

error importing from AS00

I am trying to transfer with dts a table of As400 into a db sql-server.

But i receave un error (2147217865)

With Access i can import the table with the same ODBC.

You have some suggestion ?

thk by Logan bye bye[posted and mailed, please reply in public]

Logan (logan1577@.hotmail.com) writes:
> I am trying to transfer with dts a table of As400 into a db sql-server.
> But i receave un error (2147217865)
> With Access i can import the table with the same ODBC.
> You have some suggestion ?

There wasn't an text with the error message? You are terribly short on
details, but since I don't use DTS nor know anything about connecting to
AS400, I would not be able to say that much more.

However, I did look up the error code in a book I have, and if the error
comes from the OLE DB provider, the error is "The specified table does not
exist". Whether that refers to the table on the AS400 side or on the
SQL Server side, I don't know.

You probably need to add some deubgging to your DTS package. As I
mentioned I don't use DTS myself, so I cannot really help. But you
could check out the group microsoft.public.sqlserver.dts where the
really sharp DTS people hang out.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp