We are using Quest Geo Solution's Grid InQuest DLL (GIQ60.DLL) within an SQL Server Integration Services (SSIS) package. We have managed to use this without problems locally (32bit) by using tlbimp to create a .NET wrapper (interop). However, when this moved to our integration server this does not work as the server is 64bit. The GIQ6...
Hi, I am trying to create a SSIS package to load data from an excel file to a database table. The excel to import the data will not be defined at the time of creation of the package. It is available, in a desired format, only when the user specifies and locates the file on the local file system at runtime. Could anyone please let me kno...
How can I use Checkpoints while I am using For Each Loop containers in an SSIS package? Whenever I try and rerun the package it starts from the beginning of the foreach loop container instead of from where it failed. The checkpoint seems to have trouble with for each loop containers. I created a table insert to help me identify where ...
I dragged Execute t-sql statement task from toolbox. clicked new and created new connection. when i executed, it executed successfully. there was no db showing in con string. i changed the connection string to point to new server of above in Connection tab. when i executed it, i recv errr Description: Executing the query "DBCC SHRINKFI...
Hi All, We currently have a solution developed using SSIS / C#. The SSIS package (amongst other things) has a script task that uses logic developed in the class libraries. This functionality needs to remain separate from the SSIS package. Because we are using an SSIS package I understand that the compiled DLL's need to be deployed to ...
I need a .NET tool, preferably a library, that I can use in SSIS to convert Northing/Easting information from Collins Bartholomew (bartholomewmaps.com) into WGS84 with a ssrid of 4326 - to be used in SQL Server (Geography). Edit: In response to an answer given, the script looks interesting; do you think it would be easy to create a c# c...
Ok, I have a simple process... Read a table and get the rows that have a "StatusID" of 1. Simple. Select ProductID from PreorderStatus where StatusID = 1 Foreach row returned from that query, perform an action. For simplicity sake, let's just modify the original table to set the "StatusID" to 2. Update PreorderStatus set StatusID =...
SSIS is great at handling flat files where all the records are the same, but not so good when there is a little complexity. I want to import a file similar to this - Customer: 2344 Name: John Smith Item Description Price Qty 543455 Widget 1 4.00 2 543556 Widget 2 8.00 1 I want to ...
I'm attempting to use the SSIS 2008 lookup component in full cached mode with a T-SQL Query. Is there any benefit to using a ORDER BY clause in the T-sql. Here is a example: SELECT FooFK ,FooValue FROM dbo.Foo ORDER BY Foo; In this case, I'm using FooValue to lookup the value of FooFk. Also will multiple Lookups component run in pa...
I'm trying to import data from a Progress database into a MS SQL 2005 Server database. On SQL Server, I'm right clicking on my schema name and going Tasks > Import Data... and running through the wizard. I have an ODBC Connection to progress setup, no issues there, I also test my queries using ODBC Explorer first to ensure I have no sy...
When an SSIS tasks runs, I want to create a temporary table with an identity column. However the seed for this column should start with a value = Select max(columnname_from_another_table) + 1. I know SQL but not SSIS. One method I know is create the table and then issue something like 'DBCC CHECKIDENT('TempTable', RESEED, @TheCalculated...
Hi, I have litte knowledge in data transformation in SSIS and basically I am learning all by myself. II have learned some of them and now I am into Fuzzy logic. I am getting stuck in Fuzzy grouping and Fuzzy Lookup in SSIS. I cannot figure out how to do that though some google search gave me some result which are beyond my capabili...
Hi, How can I handle HTML souce in SSIS package. After some google search I found some answer here HTML Table as data source I tried to follow the same but with not the desired output. May I be helped in this regard. Thanks in advance ...
For a beginner having an experience of 6 months in SSIS what are the most probable questions? For Control tabs, Each section of dataflow tabs like what are the most used Transformations in day to day life (I know that all are important as it depends on the project requirements) etc? Thanks in advance for the help. ...
I'm trying to create an Integration Service project that will use a set of existing (legacy) databases to create a new database. As I'm a SSIS noob, my progress is rather incremental and adding a truncate on the entire target database would help me test it more easily. Is such a thing possible? ...
I would interested to hear from other developer tip on SSIS best practices, dos and don'ts, pitfalls and tricks, etc. I'm trying to introduce a few here at my company. ...
Can someone please recommend good books on SSIS and SSRS? ...
I have taken ownership of a very complex SSIS package with multiple files and routes. Is there an easy method of process mapping the whole process automagically so I can print it out and understand it? Edit: Added a screenshot of an example SSIS package that I need to map. Cheers, Ian. ...
Hi I have a SSIS 2005 package that needs to read from an XML file, parse into columns and load into a SQL table. I have the parsing working ok. My problem is that I won't know the table name until runtime. The tables are named transaction_x where x is held in a package level variable. Is there any way I can set the destination table na...
To begin with, I know very little about DTSX files and SSIS, but my boss wanted another pair of eyes looking at this problem. Apparently there were some problems running nightly jobs. From what I've been told, the DTSX files being used had to be recovered with an undelete tool and apparently that wasn't successful. We now have some DTSX...