February 29, 2008 at 1:52 pm
Hello,
I am trying to create a package using SSIS. I need to transfer 3 tables from sql server 2000 to sql server 2005.
I do not know what control to use. I used Transfer SQL Server objects task but with no success.
SSIS package "Transfer Call Stats.dtsx" starting.
Information: 0x4002F418 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Logins to transfer.
Information: 0x4002F41D at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Users to transfer.
Information: 0x4002F362 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Rules to transfer.
Information: 0x4002F370 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Views to transfer.
Information: 0x4002F358 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Stored Procedures to transfer.
Information: 0x4002F374 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no User Defined Functions to transfer.
Information: 0x4002F378 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Defaults to transfer.
Information: 0x4002F382 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no User Defined Data Types to transfer.
Information: 0x4002F386 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Partition Functions to transfer.
Information: 0x4002F390 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Partition Schemes to transfer.
Information: 0x4002F394 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no Schemas to transfer.
Information: 0x4002F398 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no SqlAssemblys to transfer.
Information: 0x4002F402 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no User Defined Aggregates to transfer.
Information: 0x4002F406 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no User Defined Types to transfer.
Information: 0x4002F410 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: There are no XmlSchemaCollections to transfer.
Error: 0xC002F325 at Transfer SQL Server Objects Task, Transfer SQL Server Objects Task: Execution failed with the following error: "ERROR : errorCode=-1071636471 description=SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E37.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E37 Description: "Invalid object name 'dbo.VXTrackerStatsWithDuration'.".
helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}".
Task failed: Transfer SQL Server Objects Task
Warning: 0x80019002 at Transfer Call Stats: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "Transfer Call Stats.dtsx" finished: Failure.
The program '[712] Transfer Call Stats.dtsx: DTS' has exited with code 0 (0x0).
February 29, 2008 at 3:18 pm
Does this table, dbo.VXTrackerStatsWithDuration, exist in the source?
Are you running the package in BIDS or on the server?
Does the account that the package is running under have permissions on the source and the destination (create table)?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 29, 2008 at 3:49 pm
Thanks for your response.
1)Yes
2)BID
3)Yes
I figure out how to do it. I used the wizard and this save a copy. But now I am trying to understand how this works. So I am creating a new one.
In the data flow I am using OLEDB Source and OLEDB Destination. Both are pointing to the right servers. But I am getting this error now.
This component has no available input columns.
Do you want to continue editing the available properties of this component?
March 3, 2008 at 7:19 am
then u need to double check with your oledb source check the source file n see the preview if evrything wrks good then try running it ....there is some problem with ur source if doesnt wek try posting some details may be i can help...
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
March 3, 2008 at 7:26 am
jvisagl (2/29/2008)
Thanks for your response.1)Yes
2)BID
3)Yes
I figure out how to do it. I used the wizard and this save a copy. But now I am trying to understand how this works. So I am creating a new one.
In the data flow I am using OLEDB Source and OLEDB Destination. Both are pointing to the right servers. But I am getting this error now.
This component has no available input columns.
Do you want to continue editing the available properties of this component?
Check out this article:http://www.sqlservercentral.com/articles/Integration+Services/61824/
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 29, 2008 at 12:34 am
drag and drop the green arrow from oledb source to destination.
April 29, 2008 at 2:42 pm
Thanks a lot!
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply