I agree that permanent staging tables would be a better option than true temp tables (# tables).

One option to consider:

1. create 25 staging tables with the exact schema (including constraints,...

Please post all error messages.

For that you could leverage Package Configurations SQL Server storage. Not sure about why you think you need to lock the row but maybe that's specfic to your environment. That...

aaron.reese (1/9/2013)

---

I know I can share an XML config across packages, but can I have a package pick up more than one XML file? I.e. a global XML with...

Yvan Bouchard (1/9/2013)

---

Saw that article - talks about the same kind of problem and solution we used but still does not explain why making...

Needing to know the DDL is a pain. That part could be made to be dynamic although I would be compelled to drop 'somewhat' from 'somewhat messy' at that point...

No. In my repro code both tables are empty. I am thinking it has...

Relevant?

SSIS: A performance tuning success story

Is PowerShell installed on the server? You could do this in a CmdExec step type:

%windir%\System32\WindowsPowerShell\v1.0\powershell.exe -ExecutionPolicy ByPass -Command "& {$x=(Get-Date -Format "yyyyMMdd_HHmmss");Move-Item -Path "C:\@\FlatFile.txt" -Destination "C:\@\FlatFile_$x.txt"}"

Just change yyyyMMdd_HHmmss to match...

My apologies for the late response. I did not realize there were new topics posted in this area. In case you have not seen the third of the three articles:

Using...

I wasn't sure the crux of your issue so I threw some code out there thinking it might initiate a discussion. I am happy to help move the ball down...

Windows has no native support for SSH. You'll need to incorporate some third party software.

tom 100 (1/8/2013)

---

Thank you- I have another question relating to the same file.

I have two columns in the CSV file, Contact Name and Company. The Contact Name is duplicated in...

MyDoggieJessie (1/7/2013)

---

By default when installing SQL Server the built in administrators group is added into the sysadmin role, so as long as you/they can connect to the SQL Server instance...

dwain.c (1/8/2013)

---

a_ud (1/8/2013)

---

I just didn't think of it, but thank you. I've checked the TRUNCATE command and apparently one of the best things about it is that it doesn't fire...