Creating Dynamic Outputs in SSIS
In this article, we'll see how you can use the Foreach loop and the Expression Language to create multiple, dynamic outputs through object reuse.
2009-09-24
12,267 reads
ETL (Extract Transform and Load)
Flat File Imports with SQL Server Integration Services 2008
A main function of SQL Server Integration Service is to move data into and out of SQL Server. The external data source can exist in almost any format, including a plain text file. This article focuses on importing a text file into a standard SQL Server database table.
2009-08-20
4,444 reads
2005-03-31
1 reads
RE: Passing temporary tables as parameters in SQL Server
You can use the table variable as a return from a UDF. I have used this successfully in the past. Hope this helps! Don
2005-03-25
RE: SQL Scheduler - Not running jobs
If I need a daily task (or whatever time period), and I need to take into account server reboots unannounced, then I tend do write my own scheduler (using Perl). On invocation (which is every 5 mins or so), it checks the last run date in a status file which is written to disk after […]
2005-03-17
RE: Exporting to CSV with (") as text delimiter
Bill, Thanks for the reply. I am using just a few rows to test the export and opening it in Notepad. Again, no quotes around text fields. Very frustrating!
2005-02-02
RE: Poor Trigger Performance - Why?
As far as cutting down the number of rows processed, that is effectively what I am doing with... WHERE PoliID IN (SELECT PoliID FROM Inserted) ...(PoliID is the Primary Key field) I have tried using an INNER JOIN on the ‘Inserted’ table instead but it causes the trigger processing to take even longer for some reason. The following […]
2005-01-19
RE: How to find and replace a string in a table?
Or... UPDATE YourTable SET YourColumn = STUFF(YourColumn, CHARINDEX(YourColumn, 'mkpdc'), 5, 'SRV01')
2004-11-08
RE: Shrinking Transaction Log Files and TRUNCATEONLY
You're talking about two different things here to me - shrinking the log file(s) is quite different to truncating the log.Obviously if you truncate the log and use a recovery model that relies on the log files for recovery then you're dead if you don't backup the Db after doing a truncate log operation. If what you […]
2004-11-03
RE: log shipping in disaster recovery
For the logins, you could do a BCP out of the syslogins table on a nightly basis and copy the output file to the second server. As part of our Distaster Recovery, we bcp out a view of syslogins other than the standard system logins (such as sa). Then, you could BCP them in when you need […]
2004-10-18
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers