How Do I Reach For a Text File (Source) for File Name With Part
Static and Part Dynamic
Thu, 5 Jun 2008 08:51:17 -0700 (PDT)
Thanks in advance.
I have just read a post on www.sqldts.com titled "How can I change the
filename for a text file connection?". The example provided gives me
excellent detail on how to create a text file (destination) with a
changing name based on date which I currently use.
How do I reverse the principle ...
|
Question on Activex script in DTS
Wed, 04 Jun 2008 16:26:00 -0400
I'm trying to bring over a text file into a SQL table, and the data has
got what appears to be low values in a field on it.
It's causing a problem when I try to load them into a table though. It
doesn't set it to spaces (which I am looking for later on to edit any
unfilled field) but with something else th ...
|
Business Intelligence Development Studio Not Available
Wed, 4 Jun 2008 08:22:11 -0700 (PDT)
Hello all,
Please forgive me if I've posted this to the wrong group but I figured
this was a start!! I installed SQL Server 2005 last year on my Dell
laptop. Now I need to create SSIS packages. Therefore I installed
Microsoft Visual Studio 2005. On a co-worker's machine Business
Intelligence Development S ...
|
how to troublshoot smtp send mail SSIS task
Tue, 3 Jun 2008 21:55:01 -0700
I have a simple SSIS package that runs a sql query that exports to a flat
file, then emails this flat file to an address. I built the package in Visual
Studio 2005, where the package runs without a problem. I save the package out
to a sql 2005 sp2 server, and the package fails on the send mail tasks:
Microso ...
|
System hangs when right clicking transform task with Oracle data s
Tue, 3 Jun 2008 12:40:03 -0700
I set up a DTS package using an Oracle connection and a SQL Server
connection. For the Oracle connection, I used the Microsoft OLE DB
Provider for Oracle. For the SQL Server connection I used Microsoft OLE DB
Provider for SQL Server. When I set up the transform to go from SQL Server
to Oracle and right ...
|
Calling Global Variable in DTS
Tue, 3 Jun 2008 12:06:01 -0700
I have 5 folders each having 2-3 text files.
I have two DTS(SQL 2000) packages one which is having around 12 tasks which
is getting processed based on the records in '.txt' file, now what i need to
do is put this entire first package in a loop which will get the name of the
file from my second package which i ...
|
Partial Fuzzy Lookup?
Tue, 3 Jun 2008 10:02:03 -0700
I need to do a partial fuzzy lookup in SSIS. This means that some columns
need to match exactly, while others are fuzzy matched. Picture an incoming
data stream T1 with two columns T1_C1 and T1_C2, and a lookup table T2 with
columns T2_C1 and T2_C2. Stream T1 has 16,000 rows, and lookup T2 has
215,000 row ...
|
|
|
DTS Transformation Error
Tue, 3 Jun 2008 08:40:03 -0700
I am using an already developed DTS package that I created for a new
database. Everything looks the same here. Except now I am getting this nasty
transformation message...
An error occurred when you tried to submit changes to this transform. Please
refer to the following error message and make sure that you ...
|
Re: SSIS Global Variables - Have to manually set ReadWriteVariables
at Design Time??
Tue, 3 Jun 2008 02:21:30 -0700 (PDT)
Hi Justin,
I sent you a mail earlier, but thought I might answer here in more
detail. Unfortunately I no longer have the package that I made for
RMoore, but the concept is pretty simple. Basically, all I did was
add the variables that contain the variable names and values that you
want to set dynamically in ...
|
SSIS Global Variables - Have to manually set
ReadWriteVariables at Design Time??
Mon, 02 Jun 2008 08:27:18 -0700
I am having the same issue with setting SSIS Global Variables at the child package level without wanting to manually hard-code them into ReadWriteVariables at Design time. Can someone email me the package that you have that seems to solve this problem? tubbytreats aT gmail ...
|
