I have to import a log file to SQL Server Database. File size is big, around 6MB with 40000 lines. The task of importing has to be done everyday with daily log. Each line of the log file contains many fields, which I have to import into properly columns in Database for post-processing. I'm confused of these solutions: -Use SQL Server I...
I'm looking for an implementation of this Enterprise Integration Pattern http://msdn.microsoft.com/en-us/library/ms978583.aspx explained in a more general way on http://www.eaipatterns.com/Messaging.html Does an Open Source implementation of "Message Bus" (or message queue) pattern exist for Delphi? ...
So, I have Integration Services packages that need to work with Excel files (shudder) and also need to execute on x64. I have a handle on the whole SSIS x64 vs. 32-bit issue, so I am scheduling these problem-child packages using MS suggested technique of using SQL Agent job step type Operating System / CMDExec, with a command line string...
I am attempting to use EzAPI to develop packages for Microsoft SQL Server Integration Services. In almost all cases, things work very well. However I am having trouble developing a package and data flow that reads from a SQL Server data source, passes the data to a Cache Tranform for caching and routes in into a Cache Connection manage...
I am trying to find some development best practises for SQL Server Reporting Services, Analysis Services and Integration Services. Does anyone have some useful links or guidance they can offer on this subject? ...
Are there any interfaces provided by OpenVMS? ODBC? WebService? Attunity adapters are ruled out due to Cost. Any pointers would be useful.. Thanks paritosh ...
I have developed an SSIS custom task component. It uses a connection manager of the ado.net variety to do its database work. I'm in the processes of adding a GUI to the component and I can't find a way to filter/display just ado.net connections. I'm using the following code to load the connections into a list box. //Load up C...
Hi folks, I am struggling with an SSIS (SQL Server Integration Services) related problem for over two days now, so I decided the ask you. ;-) Following Setup is given WebServer / Application Server Database Server with SSIS The Database Server is also hosting a webservice that does calls local SSIS Package. When calling the webserv...
We have a some ETL processes that read CSV files that are output from SAS programs. I'm in the process of upgrading one of these ETLs and was wondering if I could use SSIS to read directly from the SAS dataset. Has anybody done this successfully? ...
By "variable format" I mean that each row in the text file begins with a single character code denoting the record type, and each record type has a different format. I believe this is some sort of fairly common mainframe data export method. What makes matters worse is the fact that the record types are actually hierarchies. The codes in ...
Hi all, how can i insert a blank date to sql database in ssis working with a visual basic script component? I have to transfer date from excel to database and i would like to insert a blank or null value in the database if in the excel is empty thanks ...
How can i do a isDate() control on a date like 16/01/2008 in vb.net? ...
I've hit the inevitable state where I have to do a diff on the code within two versions of a SSIS package. What have you used successfully other than what I'm going to do now by opening up 2 instances of VS and go over it box by box and variable by variable? Note: The things that are important to compare in my case are: Variables ...
I have a SQL Server Integration Services project which queries a SQL Server 2005 database using an OLE DB Source with SQL Command as data access mode. I'm trying to parametrize my SQL query but the syntax is not @PARAM and when I try to use ? and click on the parameters I get an error saying that "Parameters cannot be extracted from the...
I am new to SSIS and I am relying on a book, so this should be an easy question to answer. I want to import data from all of the text files within a directory. So I create a Foreach container. The first thing I want to do within the loop is execute a SQL task to drop and create the landing table. Then I want to load the data into the ...
I am using OLE DB data source component as a part of data flow task, but I would like to keep the sql query in an external file and not embedded in the task itself. Is there an easy way to accomplish this? ...
i created a package in SSIS 2005. this package export my tables from sql server 2005 to text files daily. on the other hand i created another package for uploading these text files to FTP site. but the size of my text files becomes bigger and bigger day by day. i have to zip them and after that upload to FTP. would u please advise me? t...
Hi Everybody, I have a SQL Server 2008 database which is located on a distant server (I have full access to this server however). On my computer I have Visual Studio 2008 installed, and I need to load a solution which contains projects that have been created using plugins from SQL Server. Those plugins are : - SQL Server Analysis Servic...
I have a ftp task that takes files from a server looking for a especific file name generated with a expresion and its working fine. But, now i need to download every file in a specific folder no matter the name it has, but the ftp task ask me for a specific file name. How can i do this. tnks. ...
Im runing a SISS that read several txt with some data, the first 50 files went fine, but, when I get to december data I get this error: There was an error with input column "fecha" (1206) on input "OLE DB Destination Input" (79). The column status returned was: "The value could not be converted because of a potential loss of data.". T...