SQL_Learning (5/3/2013)

---

-- but the thing is in execute process task

Execute process task 1 --- i am selecting all the .txt files and moving them

Execute process task...

SQL_Learning (5/2/2013)

---

Hi,

I was trying to get all my .txt and .csv files from one folder and move them to another folder so, how can i do...

dfulks (5/1/2013)

---

I have inherited an SSIS package that has over a dozen Execute Package Task controls in it. They are all contained in one "master" package and that package...

Can you create a connection name which does not contain any spaces and try that?

That file does not exist. Remove the wildcard characters and use the real file name.

Daniel Bowlin (4/29/2013)

---

I suggest you read these 2 links

http://consultingblogs.emc.com/jamiethomson/archive/2006/12/20/SSIS_3A00_-Using-stored-procedures-inside-an-OLE-DB-Source-component.aspx

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/e8645006-899a-40bb-b144-6d65ee0a6290/

So the real challenge is getting the data out of the stored procedure. You could build a work table and then

INSERT...

brian.geregach (4/16/2013)

---

First off, my appologies, I am a newbie to programming and SQL.

Setup:

I have an SSIS package that inserts rows to a database. On...

I do not think that the wildcard character * is valid in file names - assuming that that is your question?

Use an Execute Process command at the end of your package to run a DOS copy/append:

copy file1.txt+file2.txt+File3.txt+File4.txt AllFiles.txt

If you can find any way that you can re-engineer this process so that you do not do any sorting or grouping within SSIS and instead use the SQL Server...

prakashr.r7 (4/25/2013)

---

Phil Parkin (4/25/2013)

---

By 'Load' what do you mean? Just INSERTs, or INSERTs & UPDATEs? Or something else?

If just INSERTs, SSIS should eat that up with no need for any...

By 'Load' what do you mean? Just INSERTs, or INSERTs & UPDATEs? Or something else?

If just INSERTs, SSIS should eat that up with no need for any 'batch processing' -...

What is your question?

Eric M Russell (4/24/2013)

---

Karan_W (4/23/2013)

---

I am using SSIS 2008. The task is following.

1: Execute a storted proc and using the output create a CSV file.

2: this CSV file need to...

One thing which I can see holding this solution back as volumes increase is that the multiple EXECs are essentially single-threaded - they run sequentially.

A better-performing solution may be to...