blux2013
Last Activity: Jun 13 '13, 08:15 PM
Joined: Jun 11 '13
Location:
-
While debugging the script I check the variables in the local window. -
The execute SQL steps are working and the variables are being populated properly. Well, at least I feel better that I wasn't missing something obvious. Thanks for taking time to work with me on this.Leave a comment:
-
Here is the xml:
...Code:<?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts" DTS:ExecutableType="SSIS.Package.2"> <DTS:Property DTS:Name="PackageFormatVersion">3</DTS:Property> <DTS:Property DTS:Name="VersionComments"></DTS:Property> <DTS:Property DTS:Name="CreatorName">VALPO\blux</DTS:Property>
Leave a comment:
-
Here is the error message:
Error: 0xC002929C at Transfer Database Task, Transfer Database Task: The transfer file information "","","" is missing the filename.
Error: 0xC002929D at Transfer Database Task, Transfer Database Task: The transfer file information "","","" is missing the folder part.
Error: 0xC002929C at Transfer Database Task, Transfer Database Task:...Leave a comment:
-
Ok, I set the the variables to evaluate as expression = false, but it still is returning the transfer file information "","","" is missing filename, folder part errors.Leave a comment:
-
Not sure what exactly you need, so here is all the xml:
...Code:<?xml version="1.0"?><DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts" DTS:ExecutableType="SSIS.Package.2"> <DTS:Property DTS:Name="PackageFormatVersion">3</DTS:Property> <DTS:Property DTS:Name="VersionComments"></DTS:Property> <DTS:Property DTS:Name="CreatorName">VALPO\blux</DTS:Property>
Leave a comment:
-
Yes, evaluate as expression is set to true as well.Leave a comment:
-
The expression for the SourceDatabase is coming from a variable @[User::DbName] and the SourceDatabaseF iles are being populated with the following expression:
During debugging I can...Code:"\"" + @[User::FileName] + "\", \"" + @[User::SrcPath] + "\",\"\"; \"" + @[User::LogName]+ "\", \"" + @[User::SrcPath] + "\",\"\""
Leave a comment:
-
SSIS Transfer Database Task missing transfer file information
I'm an SSIS newbie and I'm trying to create a package to automate the migration of 60+ databases. Everything appears to be in order but the Transfer Database Task fails with
The transfer file information "","","" is missing the filename.
It also gives the same error for the folder part, and says it could not find the file"\" in the source database "foo".
...
No activity results to display
Leave a comment: