Delete Rows from SQL DATABASE BEFORE Import To THE SQL DATABASE USING SSIS
How to Delete Rows from SQL DATABASE BEFORE Import To THE SQL DATABASE USING SSIS

Answer Question   |  May 30, 2009  5:01 PM
SQL Database, SSIS, SSIS 2008, SSIS Package 2008

Writing directly ot iSeries optical drive
We are creating a file that is being copyied to the IFS using the cpytoimpf command. This is working fine. But the problem is that the file is for a State agency that is requiring that the file be sent on a CD for security instead of emal which would be our normal process. Is [...]

Answer Question   |  May 18, 2009  2:42 PM
AS/400 SSIS, iSeries, Optical Drives, SSIS

Execute SSIS package in SQL Server 2005
how to execute SSIS package in sql server 2005

Answer Question   |  April 15, 2009  11:02 AM
SQL Server 2005, SQL Server 2005 Integration Services, SQL Server Integration Services, SSIS, SSIS Package

Migrating DTS packages to SSIS
What is the tool that migrates DTS packages to SSIS, and how effective is it?

Answer Question   |  April 8, 2009  8:25 PM
DTS packages, SQL Server, SSIS, SSIS Package

Tool for migrating DTS to SSIS
What is the tool for migrating dts to ssis.And how effective it works.And I want migtate 500DTS packages to ssis how much time it will take?

Answer Question   |  April 7, 2009  5:48 AM
Data Transformation Services, DTS, SQL Server Integration Services, SQL Server migration, SSIS

Delete names from an email list in SQL Server Integration Services
How can I delete names from an email list in SQL Server Integration Services?

Answer Question   |  April 7, 2009  5:52 PM
SQL Server Integration Services, SSIS

split column into column
I need to Split the single datetime column into separate date and time column in SSIS package and exprot the data into Excel Sheet. Can any one guide how to do it ? Thanks in advance.

Answer Question   |  March 20, 2009  5:12 PM
Microsoft Excel, SQL Server 2005, SSIS

SQL Export to Excel file column?
I need to create a SSIS Package in which the data is export to Excel file the problem is the date and time column in sql there is one column and i need to separate it into two column can any body help e i thid? thank in advance

Answer Question   |  April 4, 2009  1:13 AM
Microsoft Excel, SQL Export to Excel, SSIS, SSIS 2005, SSIS Package 2005

Using SSIS to populate SQL Server Data Warehouse
I am just wondering if anyone has tried using SSIS to extract data from iseries tables to insert into Sql Server tables?

Answer Question   |  March 12, 2009  2:33 PM
AS/400 tables, SQL Server tables, SSIS

iSeries to SQL Server via SSIS 2005
We have multiple DB2 Schema’s that are indentical. iSeries tables built using DDS. Looking for a way to use a varible to declare schema vs. having hard coded SQL Statements in SSIS.

Answer Question   |  March 6, 2009  4:56 PM
iSeries Data Source, SQL Server, SSIS, SSIS 2005, SSIS Package 2005

SSIS and Microsoft Excel
I have a road block that I need to find a work around for. I work on a system where the Databases reside on a soley database server (SQL 2005). I need to run a stored procedure on a nightly basis and export the results into a template excel file and put out on shares. [...]

Answer Question   |  February 24, 2009  4:43 AM
Microsoft Excel, Microsoft.Office.Interop.Excel, SQL Server 2005, SQL Server 2005 import/export, SQL Server 2005 interoperability, SQL Server Integration Services, SSIS

SSIS cache
We are developing packages in a SSIS environment using Version 9.00.3042.00. I’m presently having problems or a misunderstanding on when to use Partial or Full cache on lookups. Seems like the lookup results differ when using these two modes. For example, full lookups often “succeed” (turn green) but result in no matches while changing the [...]

Answer Question   |  May 5, 2011  1:06 PM
SSIS, SSIS 9.00.3042.00, SSIS Lookup Cache

What permissions are necessary to allow an SSIS script to read an excel file in a SharePoint Library?
I am developing a datamart to feed Performance Point dashboards/scorecards. To deal with managers who do not have a database source, I will have them submit an excel 2003 file to a SharePoint document library (by email). the excel file will have a consistent format. I am developing an SSIS script that will run every [...]

Answer Question   |  February 3, 2009  4:57 PM
BI, Business Intelligence, Data Connector, Excel 2003, Excel Services, Microsoft Excel, Performance Point, SharePoint, SharePoint permissions, SSIS, SSIS Sharepoint

delete list in Sharepoint using SSIS
Hello, I know how to load a SQL table into a Sharepoint list. My problem is I don’t know how to delete it using SSIS. I am aware that there is a caml solution for this;however, i am unfamiliar with the language. Can anyone provide a solution for this problem? Thank you

Answer Question   |  January 13, 2009  8:24 PM
SharePoint, SSIS

How to process partitions (Full) in analysis services
Hi, I have a cube which on a daily basis partitions will be created Partition names: shipment2008_12_31 shipment2009_01_01 shipment2009_01_02 shipment2009_01_03 shipment2009_01_04 …. . . . . I have to process the partition based on the day. If the day is 03 jan 09 the package has to process shipment2009_01_03 (Full partion processing) If the current [...]

Answer Question   |  January 12, 2009  6:08 PM
Partion processing, SSAS 2008, SSIS, SSIS Package 2008

SQL Server 2008 SISS error row handling
Struggling with SISS I have data source and data destination With some bad data, I can’t figure out how to set up sending the bad row to another destination There are over 50 columns. Sorce is a tab delimited text file Desitnation is SQL Table

Answer Question   |  January 5, 2009  9:27 PM
SQL Server 2008, SQL Server 2008 Integration Services, SQL Server Integration Services, SSIS

SQL SERVEUR 2005 SISS AND WHERE statement
I create a SSIS to transfer the date from AS/400 TO SQL Server 2005, and it’s work fine. when I go to modify it and I add a where statement to choose only the year 2008, I received the following error code 0×80131937

Answer Question   |  December 5, 2008  5:24 PM
Error 0x80131937, SQL 2005, SQL error messages, SSIS, WHERE statement

ExcelSource file – metadata validation
I need some assistance. I am using an excel file to import data to SQL tables. The problem I am running into is having to replace the metadata of the output columns with the metadata of the external columns. I do not want to do this manually everytime. [The metadata of the following output columns [...]

Answer Question   |  December 5, 2008  4:44 PM
Excel Metadata, Microsoft Excel, SQL tables, SSIS

MaximumErrorCount
HOW DO I CHANGE THE MaximumErrorCount IN SSIS

Answer Question   |  May 10, 2011  3:54 PM
SSIS, SSIS MaximumErrorCount, SSIS Package, SSIS Package 2005

SSIS package using dynamic configurations
Hi I have to create a package which process the analysis services cube and its partitions,and dimensions. This package should run every 15 minutes to process the cube. I have a procedure which creates the database in analysis services db and relational db for the current month. I have another procedure which creates daily tables [...]

Answer Question   |  November 10, 2008  5:28 PM
SQL Server Analysis Services, SSAS 2008, SSIS, SSIS Package 2008