Hello
I have a flat file and sql database
when i try to run the project it's always import the half of rows for example if there is sex rows in the flat file its import three rows only so ...
Hi,
I have a oledb command which is executing a store proc which has got an output value, I want to store that output value in a varaible in inegration services package.
Is there any way I...
Hi
Having real problems getting a string held in source csv file into a datetime SQL table using SSIS Derived Column Transformation. The relevant csv column holds date information in the form...
hi Experts,
My log file for the database is grown to full. I need to truncate that file, can anybody give me steps on how to do that?
Thanks
Hi I am very new to SSIS so the answer to this may be very easy indeed - dont forget to suggest the obvious!
I am importing a csv file in which the first column represents a date, and is in...
Hello!
We have an SSIS package that simply copies a table from an Access database (located on network) to a SQL table. The package runs successfully if executed in Visual Studio. When a j...
Hello,
1. I have lot of different tables data to be extracted to flat files like table1, table2, table3.....tableXXX.
2. I need to run select * from each table and capturing the data in flat...
I am trying to set up a SSIS package which uses a FTP task to download a file. In the FTP task editor I have the filename setup as an RemotePath expression. If I do not put a / at the start of...
Hi,
I have been struggling for the past day or so trying to get a text file to FTP to our as400 box.
The FTP task is the last part of a larger SSIS package I have developed and it's driv...
I am new to SQL 2008 and SSIS packages. I am importing a text file to a table in my database. The text file has a date field in the format yyyyMMdd which is causing the import to fail. How ...
HI there
I've been using the code below to splitting the "," (Comma delimited) in the Script Tranformation Editor.
Now it works well if the data like this:
TEST,TEST1,TEST2
The recor...
Hi.
I am using BIDS from VS 2008.
I want to create a package for following
I have a lookup table with column StationID (200 distinct records). The OLEDB data source also has a column ...
I have a third party application that outputs logs as dbf files (dbase iv it seems).
The logs show up in the following format:
DateTime Event0 Value0 Event 1Value1 Event2 Value2 .......
How do I configure an ssis package so that it sends out email using the from address of a mailbox to which the account running the sql agent job has 'send as' permisssions?
Hello, I have a question about SSIS. In Visual studio 2008 I create packages to transfer data to my staging area. In my package I use a lot of Sequence containers, Sequence containers in other...
I am working on a 2005 SSIS project, I need a for each file loop container to loop through some files in a folder to be processed. Is there a way I can configure the container to use a variabl...
I have two data columns which I am trying to join in a ssis lookup. The data type of the first column is DT_WSTR and the second column is DT_STR.
What is the difference between the two data...
I'd like to execute a SSIS package from within a VBA module in Excel 2007. Can someone direct me how to do that?
Where in the FTP task should I define the path where the files are stored? I tried using For each file loop container but I did not find option of FTP in there. Anybody any thoughts please?
Hello,
I'm looking for a way to get an SSIS's connection Manager properies through a VB.net code.
For example, we have an SSIS package with 5 different connections. I'd like to pull the c...
I have an executable file which replaces text in a text file. In DOS, the code will look like this:
Name of executable file | File to search | Output file name | Char to be replaced in HEX...
Ok.. I am creating a file once a month. Yearly a new folder must be created. And the files then go into their respective files.. The date is pulled off of a variable.
So I found FIle System T...
This week I noticed that my SSIS jobs fail that are using Visual FoxPro tables as a data source. I am using SQL 2005 Enterprise Edition on a Windows Server 2003 box.
After looking around I...
Hey guys -
I have a pretty simple SSIS package that i'm trying to run.
I have an OLEDB destination which reads in a query from a variable. Then I have an OLEDB Destination which just i...
Hi Guys ,
I have a problem with creating an expressions in SSIS Derived Column
i have an Column coming from a flat file as string actually its date time some thing like 1/2/2009:12:00:00...
