October 2010 - Posts

1
Comments

SSIS Nugget - from NULL to NULL but different datatype by MartinIsti

It's so simple yet I spent quite many painful minutes with that. The issue is that I have flat files to use as sources. They have 1 header row and 0 or more detail rows. Since I cannot divide the file in the connection manager for the header row ...
Filed under: , , ,
0
Comments

SQL Nugget - script content of a table as INSERT statements by MartinIsti

I have wrestled a couple of times what was easy when I used TOAD but became painful with SQL Server. For example you have a control table that is manually edited most of the times in DEV. When you want to move it to TEST you can transfer the whole table...
Filed under: , , ,
Powered by Community Server (Commercial Edition), by Telligent Systems