Hi Rem,

Is your issue resolved?

I am getting the same error. I restarted the server thinking it might be locked by some process.

I have observed that when the parent calls...

satish.ratnaparkhi (11/19/2009)

---

Thanks Vikas for quick reply, I already use

DBCC SHRINKFILE (DBName, Size)

for reducing my database but it not work. Database base log file size remain same.

I also run a...

http://tinyurl.com/ygfgzgq

But if you don't mind I still want to clear one confusion:

As far as my understanding is concerned, I think that variables are mapped to whatever folders are specified in...

DECLARE @SSQL AS VARCHAR(1000)

change @SSQL to NVARCHAR and it will work

read about sp_executesql on BOL.

Hey Kunal,

Can you provide us the screen shot of for each loop and the file system task.

Hi Kunal,

Your steps looks good.

But the below 2 statements are a bit confusing.

4. In variable mapping, I have selected ' new variable'...

If you use the Lynn...

Lynn Pettis (11/17/2009)

---

You may want to try this, and you may also want to be sure that you have an index on each of the table on the column email.

insert...

One more advise, don't have any indexes on the destination table when you are loading the data. Once you done with loading create the constraints and indexes you want.

This will...

A data flow task in SSIS can have multiple data sources (you multiple tables/queries), transformation and then single or multiple data destinations.

Read the about "data flow" in BOL,...

One solution is to make use of SSIS data flow tasks.

Use your select queries as source and in the destination connection specify the commit size as 100 thousand, then after...

Are you advertising your website here? This is a discussion forum not ebay

I am giving you steps for connection type ADO.Net

1. Create a Execute SQL task.

2. In general tab select the connection type ADO.Net, select/create new connection in the connection option.

3. In...

what expression/pattern you want to use.

One expression that I use is date_dabname. I use following query in SQL task and then assign the output to the variable:

select convert(varchar(10),getdate(),112) + '_'...