Forum Replies Created
Viewing 15 posts - 1 through 15 (of 95 total)
-
RE: Package fails with ERRORLEVEL(-1073741819) when deployed in Server
Elliott Whitlow (8/24/2010)
Unfortunately that is pretty typical since it is usually run in production as a different user than was used to develop it..CEWII
The query would be the same even...
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font] -
RE: Want to use SSIS to transfer records from an informix database
edowney10 (8/24/2010)
I have the connections working for informix - so that's not a problem. I'm a c# developer and have done quite a bit of sql programming in my...[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font] -
RE: Want to use SSIS to transfer records from an informix database
edowney10 (8/24/2010)
I have a situation where I need to be able to transfer records from a table in an informix database into a SQL Server 2005 database. The application...[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font] -
RE: Presedence Constraint from File System Task not working as expected
fstop (8/18/2010)
However that isn't possible because each FileName variable passed from the recordset is a fully-qualified file name. Thus, there is no 2nd set of records to loop through....[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font] -
RE: Presedence Constraint from File System Task not working as expected
fstop (8/18/2010)
With all due respect, I don't understand how that would work. It just doesn't make sense to me. Can you explain in more detail perhaps?Let me explain...
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font] -
RE: Presedence Constraint from File System Task not working as expected
fstop (8/18/2010)
Here is an image of the package:
Did you try adding another for-each component inside the for-each resultset pointing to the folder & file to be deleted?
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font] -
RE: Presedence Constraint from File System Task not working as expected
fstop (8/18/2010)
That would be a great solution, but it won't let me. It comes back with an error: "Cannot create connector. Cannot connect the executables from different containers."...[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font] -
RE: Presedence Constraint from File System Task not working as expected
The problem is that it stops all processing if it fails. Ideally, I would like the first File System Task to test if the file exists. If it...
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font] -
RE: Presedence Constraint from File System Task not working as expected
fstop (8/16/2010)
I have a Foreach Loop Container with 2 tasks. A File System Task set to delete a file, and an Execute SQL Task set to Update the database...[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font] -
RE: "File represented by ... does not exist" -- FTP Task -- Receive -- filename is var containing "*" (wildcard)
Greg J (8/16/2010)
I've got the same package in 2 different environments and it behaves differently on both.The problem...
The very first step in a package that runs every 15 minutes is...
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font] -
RE: Dynamically changing Server info for OleDB Connection
siddharth.monani (8/13/2010)
Hi,I am trying to create a package where I need to fetch server name information from one database (HQ) and then connect to all of those servers (Branch offices...
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font] -
RE: ~ delimiter problem
SSIS.COM (8/13/2010)
Hello..I am trying to bulk insert a .txt file into sql server but the file has ~(tilde) column delimiter. But it looks like there is no option for that...
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font] -
RE: WSDL link in SSIS
keywestfl9 (8/13/2010)
Thank You.I have used the config file for different servers but how do i control the wsdl link thru that and what task i use
For example
DEV
http://test-sit.com/test.asmx?wsdl
UAT
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font] -
RE: Package fails with ERRORLEVEL(-1073741819) when deployed in Server
Can you tell me your package protection level? You can try by setting it as "DontSaveSensitive".
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font] -
RE: Package fails with ERRORLEVEL(-1073741819) when deployed in Server
Description: The package is attempting to configure from the XML file "<<Config file name>>".
Hope you would have done this.. if not, can you please check whether the...
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]
Viewing 15 posts - 1 through 15 (of 95 total)