|
|
| Writing to a text file with different row formats |
| I want to create a file from data within SQL that looks similar to this.
a,b,c
d,e,f,g,h,i
j,k,l,m,n,o
p,q,r
s,t,u,v,w,x
.....
Basically there would be a "header" row (3 fields in this instance) wi... on 19-Nov-09 |
| |
|
|
|
| Challenge converting DTS Lookups to SSIS Package |
| I have already migrated a SQL 2000 DTS package to SQL 2005 DTS Legacy and it
is working fine. Now I am trying to convert it to SSIS package. It is a SQL
2005 64-bit environment and I am having issues... on 17-Nov-09 |
| |
|
| parameter for data flow? |
| Typical disclaimer: I am pretty new at this SSIS stuff.
I need to transfer 35+ million rows from Oracle to SQL Server. At the
transfer rate I have seen so far, this will take about 29 hrs. Way too... on 17-Nov-09 |
| |
|
| Excel Process Left Open using SSIS Script |
| I have code that needs to manipulate Excel using SSIS Script. This code has
been running perfectly in DTS for years. I have convered it to SSIS Script -
the actual logic is more complex than you see ... on 14-Nov-09 |
| |
|
| WMI Event Watcher - Montior for a file extension |
| I am writing a SSIS package (SQL2005) and need to watch a folder for the
appearance of a text file. I am using the WMI Event Watcher task. This WQL
code will correctly monitor for any file coming int... on 11-Nov-09 |
| |
|
| SSIS - OLEDB Teradata |
| Hi,
Has anyone pulled teradata table into SQL Server 2005 using SSIS.
I am using SSIS (Native OLEDB\Oledb Teradata Driver ). and I connect to
teredata and pull the data to sql server 2005 tables, th... on 11-Nov-09 |
| |
|
|
|