The query would be the same even...

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...

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...

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....

Let me explain...

Did you try adding another for-each component inside the for-each resultset pointing to the folder & file to be deleted?

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."...

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...

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...

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...

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...

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...

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

Can you tell me your package protection level? You can try by setting it as "DontSaveSensitive".

Hope you would have done this.. if not, can you please check whether the...