SSIS Packages Version Controlling.
Hello All Is there a good way of version controlling SSIS packages. Any suggestions / ideas please thanks ...
ssis
how to import data from Excel sheet to SQL Server using SSIS by counting through the number of sheets
Hi, I am doing an application where in I have to import data form excel workbook having multiple sheets and the count of the shets is not known exactly and I need to get the data from these multiple sheets to the SQL Server.I need to do this using SSIS. Please help me out..... Thanks in Advance... ...
Transform date represented as String to Date in Visual Basic
I am using SSIS and I need to transform a date. How can I transform a date in String format (e.g. 14/09/1980) to the same but in date format in VB.NET? I would like the datetime format to insert it into a SQL database. ...
Import huge XML data (> 1Gb) into SQL Server 2008 daily
Dear all: I have encountered a problem that I need to import a huge XML (> 1Gb) into SQL Server 2008 daily. What I have now is a sample XML file and the XML schema of it. The XML schema is pretty complex which contains many custom defined simple type, and element with complex type such as: <xs:element name="xxxx_url"> <xs:complexT...
Advantages of using SSIS packages over stored procedures?
If I can do the required ETL requirements using stored procedures, any advantages of using SSIS packages instead? My ETL stuff is nothing major. I feel like using an old technology. I like SQL. Old technology does not equal obsolete as stored procedures won't go away any time soon. ...
SSIS Intermittent variable error: The system cannot find the file specified
Our SSIS pacakges a structured as one Control package and many child packages (about 30) that are invoked from the control package. The child packages are invoked with Execute Package Task. There is one Execute Package Task per child package. Each Execute Package Task uses File Connection Manager to specify path to the child package dts...
SSIS how can i insert a blank date to database with visual basic
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 ...
Visual basic script that control a date format
Hi all, i would like to control a string if is in the dd/mm/yyyy format and if the dd number is between 1 and 31 and if mm is between 1 and 12 Someone can help me? thanks ...
SSIS Package Error on Vista IIS ASP.NET
I'm having an issue executing an SSIS package programmatically in a web application during development on my machine. The package imports the contents of a flat file into SQL Server. The file path (data source) of the flat file connection is a local path on my machine, which is passed to the SSIS package as a variable. (All resources are...
isDate control on european data in vb.net
How can i do a isDate() control on a date like 16/01/2008 in vb.net? ...
How do you get an SSIS package to only insert new records when copying data between servers
I am copying some user data from one SqlServer to another. Call them Alpha and Beta. The SSIS package runs on Beta and it gets the rows on Alpha that meet a certain condition. The package then adds the rows to Beta's table. Pretty simple and that works great. The problem is that I only want to add new rows into Beta. Normally I wou...
Master-detail migrate in SSIS 2008
Hello all! I have two MSSQL 2008 databases dbA and dbB, dbA contains master-detail tables pair: AMaster, ADetail. Corresponding it dbB also contains BMaster and BDetail. The only one difference betwee A and B is type of primary key. In source database (dbA) it is integer but in destination (dbB) it is uniqueidentifier. Dear colleagues:...
DTSX files - How to peruse & edit
I have a DTSX file in a project I'm taking over. I have Visual Studio 2005 Pro, but it just opens it as an XML file. SQL Server Management Studio 2005 does the same. I've seen people opening these files in some workflow-esque format; Business Intelligence Development Studio comes to mind. Is this part of Visual Studio or SQL? Does it...
Filemaker to SQL Server via SSIS
I'm using SSIS and trying to import data from Filelmaker into SQL Server. In the Solution Explorer, I right click on "SSIS Packages" and select SQL Server Import and Export Wizard". During the process, I use my DSN as the source, SQL Server as the destination, use a valid query to pull data from Filemaker, and set the mappings. Each t...
MySQL to SQL Server transferring data
I need to convert data that already exists in a MySQL database, to a SQL Server database. The caveat here is that the old database was poorly designed, but the new one is in a proper 3N form. Does any one have any tips on how to go about doing this? I have SSMS 2005. Can I use this to connect to the MySQL DB and create a DTS? O...
SSIS - Change Null columns to empty strings
I have an SSIS Package that is copying data from a column that is Nullable to a table where the same column is not Nullable. There is red tape involved in making the source not nullable so for now I need a way to change the nulls to empty strings. I get the data from an ADO .Net Source, not a query where I could just add a check for nu...
How do I add columns to data from a Flat File Source in SSIS?
I have a Flat File Source that reads data from a file with two "columns" of data. One is an ID and the other is a date. I want to read this data from the file and "dress" it with two more columns before I write it to the database. I want to add one column with the value of getdate() and one column with just a 1 in it. How can I do this?...
SSIS: Strip Characters from Flat File
What's the best way to strip out characters from flat files in SSIS? In my case, I need to remove all quotes from the file before processing. EDIT: How can I run an executable against some files from SSIS? Can I somehow use the source connection as an input or would I have to pass in the file names as parameters? ...
Declaring package variable in SSIS of type int? (nullable int)
How can I declare a package variable in SSIS as int? (nullable int). Ex: if I got variable Var1 as int in SSIS which maps to my db column (nullable). when ever my db column is null Var1 is getting set to 0. How can this be handled. thanks ...
SSIS Package failing with New structure of Flatfile
Hi SSIS package is just importing from txt file to sql database. when we made the package were using old file and its executing fine.the old source file got (10 columns) the new source file got 15 columns. when the source file changed its failing. [Flat File Source [1]] Error: Data conversion failed. The data conversion for column "Co...