Is there a simple way to pass a value to an SSIS variable(I don;t know VB so script task is a pain to me)? I want to pass the result of a select statement to a variable. Any ideas? Thanks in advance.
View Complete Post
Hi all members.
I need to ask for the following code. I need to convert the variable into a string.
"Select Distinct convert (int ,A.CustomerCategory) as AccountReceivableCategoryID, convert (varchar(40), B.Text) as AccountReceivableCategoryNameE
from Inkunde A , inpara B
where A.CustomerCategory= B.SearchItem
and B.Language1 = 'EN'
and B.ParameterName = 'CATEGORY'
and A.CustomerCategory = (DT_STR,200,1252) "+ @[User::CategoryID] +"
Order By A.CustomerCategory"
Kindly any member let me know, How to correctly use the Type Cast fucntion in variables
Thanks and Best Regards,
When I get my resulting xml from a webservice task, the response is not only well formed, but actually valid. When I put it into a string variable for passing it along to the next task in SSIS, the XPATH against it in the XML task it fails because
what happens is the XML got munged as it went into a string. All the quotes got escaped and all the linefeeds and newlines ended up as \r\n, etc.
Is there a way to avoid this or recover from this without having to save the xml to file and then load the xml from the file for the next task?
I am importing data and wand to assign a fixed value to an output col. the fixed value should be a uniqueidentifier maintained in a variable so that it can easely exchange prior to execution. My problem is that I realized that there is no variable type for uniqueidentifier. When trying to store the guid in a string variable and then trying to cast back using a script component i received a casting exception telling me that a string cannot be converted into a guid.
I dont want to use an object type because then i would have to manually read out the variable a execution start.
Does anyone have experience using varialbes and guids?
Thanks a lot
IÃÂ´m trying to put the count or the max value of an slq statement in to a variable and IÃÂ´m not able until now.
I have a global variable named vMax and a OLE DB connection to a DB.
The Quiery works fine and a get a result depending of Count or Max from 15000 for Count and 2000849400 for Max.
I tried all Variable types as int16, int32, double,... nothing works and I get allways the same error mesage.
Error: 0xC001F009 at xyz: The type of the value being assigned to variable "User::vMax" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object.
I tried now everything and I was not able I have now only this execute SQL Task in my project and it does not work.
My goal is to copy all new records from Table1 in to Table2.
So I create an Execute SQL Tast to get the max ID and to use this for a sql command in the OLE DB Source.
Thank you in advance for any help.
Im still trying to get this work and found one thing out. The ID that I'm using to find the Ma
I have having trouble getting my hands around how toÃÂ retrieve variables from a parent package.ÃÂ I read about the Environment variables and Configuration File at the parent package level and the Parent Package variable at the child level.
Here are my questions:
1.ÃÂ Can you only store/retrieve 1 variable in a config file at a time?
2.ÃÂ Does the child package have to define the variables and if so, do they have to be the same names as the parent package?
This seems so more more complex then the DTS2000 way of passing variables to and from packages.
Any help would be appreciated.
Thanks in advance,
I have a question regarding SSIS -- How to send list object from .NET Application to object variable created in SSIS Package. In List object there are one lack records stored..This list object needs to be passed to SSIS Package. Please reply me back with
any suggestion/solutions ...Required ASAP.
Waiting for your replies.
I am trying to develop a SSIS package which will read the records from the flat file and insert them into a destination table. I have some validations written in script component. I have declared two Read Write variables with package level scope. when i try to assign a value to the variable in the script component and run the package, the package throws me an error "The collection of variables locked for read and write access is not available outside of PostExecute".
What should be done to over come the problem please help me on this regard
I am working on the SSIS FTP Task that transfer file from one FTP server to local location, rename the file name, and finally transfer the renamed file to another FTP server. So I defined 2 FTP tasks.
For the FTP file receive operation, I need the remote path to be updated by a script and pass to the user define variable. So I set TRUE to IsRemotePathVariable. In the RemoteVariable, I set User::FTPSourcePath where the variable is set in the script with "/DMFTP/filename1.jpg"
For the FTP file send operation, I set TRUE to IsRemotePathVariable. In the RemoteVariable, I set User::FTPDestPath where the variable is set in the script with "/DestFTP/"
After all the setting, the FTP Task box show me the error as "Variable "FTPSourcePath" doesn't start with "/". Another FTP box show me "Variable "FTPDestPath" doesn't start with "/"
Can anyone help me on this problem?? Thanks.
I have one xml file in some share network drive which I want to load.
I can load the XML file into XML Source. But Can I save that XML data into some XML variable that I can pass into a stored procedure? if Yes How Can I save the XML into a XML variable in SSIS.
If the above is not possible, I was thinking to pass the XML File path to the stored procedure and from with in the SP I will use "SELECT * FROM OPEROWSET (BULK..." to load the XML into variable and process.
Please advice which method I should opt here if I look into performance and multiuser case?
I have a stored procedure insertXXX that has one OUTPUT parameter of type numeric. The stored procedure looks like:
PROCEDURE [dbo].[insertIntoTable]@outputID AS numeric OUTPUT