Cheers!...

uncle_boris (5/13/2015)

---

Thank you for the reply. I can change the destination manager value ok but can you please let me know how I...

GF (5/12/2015)

---

We are using SQL 2008.

We receive a files from different clients throughout the year.

These files contain at a minimum , company name and address. Not state or zip code

What...

Ditto.

Package will load from starting.

Change the size of your column in Flat File Connection manager first.

Then refresh the metadata of Flat File Destination.

Ensure that the variable is of the correct scope.

Thanks for you help.

I was not creating or dropping table in the SSIS package.

Issue was - while loading the table, due to large amount of data table was getting locked...

Step 1 - Load data from Source to Stage Table

Step 2 - Stage table to Main table (I am directly using the stage table in OLEDB source)

Agreed.

If it is VS 2012 or greater then we've project deployment available. So, that will be the best approach.

Also, no need for configurations ...as we've Environments feature available now.

Package 1 –

It is not a good practice to create a database and tables in SSIS packages.

I'll suggest if it is an initial load, create all databases and tables manually...

Please share some more details. Or a sample package if possible.

Try using the @@ROWCOUNT global variable.

BULK INSERT...

Great question, something new and quite useful.

If you don't have a calendar table or if you don't want to use a calendar table. Use CTE instead-

;WITH CTE AS

(

SELECT CAST('2015-03-01' AS DATE) as...

Easy way, Extract data in Execute SQL Task. Then use a For each loop container and place a DFT inside it.

Iterate thru extracted data and create Excel file for each...