Hi everyone, I have to build an SSIS package for work that takes the contents of a table, all columns, and outputs it to a flat file. The problem is, one of the columns is a varchar(5100) and that puts the total row size at about 5200 characters. It seems the flat file connection manager editor won't let me define a fixed-width row be...
I have an SSIS package that exports data from a table on a SQL Server 2005 database to an Excel Spreadsheet. The spreadsheet in question has 15 sheets, and I am trying to populate values on one of these sheets. I have a template file which I clone to be the target for the export (a simple file system task). This template file is valid, ...
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...
Hi everybody, I'm currently working with Microsoft SSIS and SQL server 2008 and I would like to write logs to a file using : Specific log pattern : Formatted Date - Log Level : Log Message Specific log levels Error Codes that are associated to error messages in a configuration file I was wandering on the Web looking for a solution...
Our project uses AcuCorp's AcuODBC driver to access a legacy Vision database. The problem is that we only have a 32-bit driver and the installer simply won't run on our 64-bit servers. I need a way to use SSIS to pull data from that system. As far as I can tell, there are 3 options: Set up a whole new SQL Server instance with SSIS a...
I'm trying to execute a MERGE statement via a Execute SQL Task, as outlined in this article: http://technet.microsoft.com/en-us/library/cc280522.aspx My MERGE statement is quite simple (see below). I can execute the MERGE statement with no trouble in SSMS, but when I put it into an Execute SQL Task, it fails with this error: "Incorrect...
I've got this to work using a very basic example(outlined below) and I want to see if other SOers have experience doing what I'm attempting...using a 3.5 framework assembly in a Script Task in SSIS 2005. I've basically followed the page found here... except I targeted the 3.5 framework while in Visual Studio 2008. Write/compile your c...
Hi If I want to Develop SSIS Package from scratch what techniques/needs to be fallow in related to design,development,testing and deployment. ...
Is it possible to run an SSIS package created by SQL 2008 Business Intelligence Studio in a SQL 2005 environment? I'd rather not have to install SQL 2005 / VS 2005 in my development environment. ...
Hi everyone, I have an SSIS package that runs a script component as one step in a series that transforms data from a flat file to a SQL table. The script component itself is pretty straightforward, but I had a question about its input and output columns. As you can see from this image the script appears to have no output columns defin...
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 converting data from Oracle Database to SQL Server and during the conversion I have to log the row which is failed and also I need to log the column name whose value caused error. For example, if there are 100 rows in Oracle database out of which 98 rows converted to SQL Server but two rows failed. The reason of the failure is the s...
This is probably an easy task in SSIS but having little experience with the tool and having failed to find the answer in the documentation, I turn to the experts here. I appreciate any and all help I might get. I've got an SSIS package that reads the contents of an Excel spreadsheet and dumps the information into a database table. Tha...
We need the ability to send out automatic emails when certain dates occur or when some business conditions are met. We are setting up this system to work with an existing ASP.NET website. I've had a chat with one of the other devs here and had a discussion of some of the issues. Things to note: All the information we need is already m...
I'm importing an SSIS package into SQL Server 2008 Integration Services . The package name contains dots and I'm getting this error message: The package name, What.No.Dots, contains characters that are not valid. The following characters are not valid: \ / : . * ? " < > | [ ] = Parameter name: What.No.Dots (MsDtsSrvr) ...
Sql Server Integration Services packages are stored as xml files with a dtsx extension. I need to be able to extract their build numbers with Powershell. The relevant part at the top of the file looks like- <?xml version="1.0"?> <DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts"> <DTS:ExecutableType="MSDTS.Package.1"> <DTS:Prop...
Looking to generate a comma separated list of languages when the ID is the same. Table 1: ID | LangID 1 1 1 2 1 3 2 3 2 4 3 1 Table 2: ID | Language 1 English 2 Spanish 3 French 4 German Want to generate results that look like: ID | Languages 1 English, Spanish, French 2 French, German 3 Eng...
My app generates SSIS packages for importing data from Excel files. This is done programatically, using C# . Before the package is generated, there's a setup step, in which I allow the user to select, from a template Excel file, the sheet name and columns to import. (Basically what you would normally do if you were manually building the...
I have simple SSIS ActiveX Script task that is returning with the above error when executing: I've cut all the code down to just an empty function: function main end function And have ensured the EntryMethod property of the component is main Any suggestions? ...
Hi, In the Flat File Connection Manager screen there is a checkbox to specify that the file is encoded as Unicode, but there is no way to tell which encoding will be used (UTF-8, UTF-16, ...) Is there an official Microsoft resource as to which encoding is used? Kind regards ...