I have an SSIS package to load data; as you may recall there are flags that are in data files as Y/N char(1) when I am trying to load them as bit flags into SQL Server. I am specifying the columns in the data file as String [DT_STR] and I have a data conversion task to convert them to booleans based on the following expression (I receiv...
When I write larger scripts in both t-sql and script components, I usually put in a boolean called debug which I can pass or set to as true that will pop up or drop debug information. For Tsql, I know it over head is negligible but is this the same in SSIS script components or VS for apps environments? ...
Is there a method where by one can read just the first record of a file; i.e to read header information, so that a decision can be made whther or not to process the remainder of the file ? I know that with the split transformation component one can write an expression that will ignore all of the rows besides the header, based on a key wo...
It seems that when using the OLE DB Command within SSIS problems occur when handling stored procedures that return xml: view bug description I have to use a procedure that is built in such a way and get hold of the xml even if it is just as a string value. Does anybody know of a workaround to the bug linked above that doesn't involve ch...
Hello, I have a pretty simple SSIS package with 3 components: OLE DB Source Fuzzy Lookup OLE DB Destination In the fuzzy lookup component I changed in the advanced tab the "Maximum number of matches to output per lookup" from 1 to 2. When I run the package after the change I get this error message: [OLE DB Destination [57]] Error:...
Hi, My .net WCF service calls a SSIS package using the Package.Execute(); method. After I call execute, I set pkg.Dispose() and app = null; The memory usage keeps climbing, 100mb to 150mb all the way to almost 300mb. I am recycling the process now, but want to know the source of the problem. Any ideas? Update The application that c...
I have a project in SSIS and I've added an Execute SQL Task which sends its result out to a variable. I wanted to confirm the value because I was worried that it would try to write it out as a resultset object rather than an actual integer (in this case I'm returning a COUNT). My first thought was just to run it in debug mode and add th...
I am deploying my SSIS packages to MSDB by configuring the deployment utility and creating the manifest file in Visual Studio (2005). In the Integration Services, I created a new folder to segregate my packages. Is there a way to specify this folder for my packages when creating the deployment utility? If not, how do I move packages in...
I am wondering if there is a way of doing a between query join in SSIS without using a temp table on my server. Given two tables, Accounts and Groups. Accounts contains a list of Accounts with a an upper and lower range to define a list of customers. Groups contain all the customers. I want to be able join the tables so that I get ...
I create a CSV-file from SSIS and I want to "publish it" in a specific folder in our Sharepoint document library. What is the preferred way to this? I have looked at the example with the sharepoint list destination SharePoint List Source and Destination which is quite good but not exactly what I'm out for. I just want to upload a file ...
I am using ssis to import large XML files. The XSD generating function is not too good. Can someone recommend a good program to creating XSD? I would like to a program to be able to create the XSD without having to understand the cryptic notation it uses! ...
Does anyone know how to execute a PowerShell script from SSIS? I have created the script and it works from from the command line. The script takes a couple of command line parameters, which work fine when called from cmd.exe. I'm using an Execute Process Task in SSIS and cannot get the script file to execute. I'm using expressions to...
How can data be imported from a Microsoft Works database (*.wdb file) into a SqlServer2005 database. Would SSIS be able to do this? ...
This is the goofiest thing I've seen all day. In SSIS 2005, I have an Execute SQL Task which runs a SQL 2005 stored proc that takes two IN parameters and one OUTPUT parameter. The IN parameters are static and so are hard-coded in the command string. The OUTPUT parameter is pulled into a package variable of type Int32 (although in the ...
I am trying to run a SSIS package using dtexec My package is deployed to a folder which has spaces in the path name This is casuing dtexec to spit out the dummy. Any ideas? ...
I have a staging table which contains a who series of rows of data which where taken from a data file. Each row details a change to a row in a remote system, the rows are effectively snapshots of the source row taken after every change. Each row contains meta data timestamps for creation and updates. I am now trying to build an update ...
Can anyone provide some information on how to run an integration services package, on an SQL server 2005 instance, from Visual Basic 6? Any help at all is much appreciated. ...
I'm trying to connect to an analysis services database in SSIS using a specific user name and password. I'm getting the message error in initializing provider. AN error was encountered in the transport layer. The peer prematurely closed the connection. Any ideas? ...
Is it true that Analysis Services ONLY supports windows authentication? ...
I'm trying to move my packages to production using a configuration file, but file is changed only partly and the results go still to DEV server. Does anybody know what to do? ...