Refresh Excel file on a different server with SSIS package
I am trying to refresh an excel file that is on different server. is there any script that can be creatted with SSIS pacage that can do this. any help will be appriciated. Thank you in advance.

Answer Question   |  November 30, 2010  8:25 PM
excel, Excel Scripts, SSIS, SSIS Package

Tool for ETL/SSIS packages testing
Which is the Best Tools for ETL/SSIS packages testing

Answer Question   |  August 11, 2010  8:43 AM
ETL, SSIS, SSIS Package, SSIS Testing

SQL To Excel Data Dumping with the help of SSIS flow task.
I am trying to do a Sql To Excel Data Dumping with the help of ssis flow task.I create a sql connection and give the query in the sql source.I aslo have a excel template to map in excel destination ready which has around 400 columns/fields.In bettween i use a dataconvrsion for unicode/non unicode issue.Now [...]

Answer Question   |  July 19, 2010  3:37 PM
Excel 2003, Excel Metadata, SQL Server database, SQL to Excel Database Conversion, SSIS Package

CPU and RAM recommendations for our data warehouse
We run a DWH with 3 databases. The first DB, called Staging, is the “input buffer”, copies the operational data, seven source systems, 12 parallel Extraction Jobs running SSIS packages. Mostly full refresh 40 GB data every night. Second DB is called catalog. Data is transformed using about 1,500 views and tables, 120 GB. Third [...]

Answer Question   |  February 25, 2010  7:57 PM
RAM, SAN, SSIS Package

remove password from SSIS package
How can I remove the password from a password protected SSIS package? I need to access its source code, but as soon as I try to open it I get the window: Enter Password. I don’t know the password. This package was created by an employee who left the company a couple of years ago.

Answer Question   |  June 2, 2009  4:05 PM
SSIS, SSIS Package, SSIS Passwords

SQL 2005 SSIS Package to load table from positional flat file
I have a positional flat file which I need to load contents into a SQL table. I’ve created an SSIS package and will need to call a VB script to parse the file but since I’m new at VB and SQL I need some assistance creating the VB script. There are 4 fields in the [...]

Answer Question   |  May 22, 2009  8:00 PM
SQL 2005, SQL tables, SSIS flat file package, SSIS Package, VBScript

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

SQL Server 2008: SSIS pakage with parameters
I need to create SSIS package with user entered date parameter. I have two questions: 1. How I can promt the parameter when I test the package in debyg mode. 2. How can I put on the begining of the package design condition: Global Variable gvar_Date datetime; If @p_Date is null Then gvar_Date = getdate() [...]

Answer Question   |  March 17, 2009  8:43 PM
SQL Server 2008, SSIS Package, SSIS Package 2008

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 that will copy a table from one server to another based on a var.
Another NeeBee question….I would like to have an SSIS package that would check if a variable “RefreshTable” = ‘YES’ which is found on a table from server A, delete all the data from a table on server B and then load that table on server B with data from an identical table which is on [...]

Answer Question   |  December 4, 2008  10:21 PM
SSIS Package

SSIS package
I am supposed to Run an sproc /script for more than one database. I thought of scheduling this sproc as a job for all database instances. But, DBA’s suggested me to go with SSIS Package. Can any one quide me in doing this.

Answer Question   |  November 6, 2008  12:57 PM
Business Intelligence, SQL Server 2005, SQL Server 2005 Integration Services, SQL Server Integration Services, SQL Server stored procedures, SSIS Package, Stored Procedures

SQL Server 2005
I need to know if and if so how I can change the name of a flat file input and keep the column information?

Answer Question   |  October 23, 2008  3:52 PM
SQL Server 2005, SQL Server Flat File Input, SSIS Package

having problem with SSIS package
i have created the SSIS package from sql server Server management and its work fine but the problem I’m having, when I try to run it from SQL Server Management jobs. Every time when train it from Sql jobs it failed. Please advice on ….

Answer Question   |  May 2, 2008  7:12 PM
SQL Server Management Studio, SSIS, SSIS Package, SSMS