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
Which is the Best Tools for ETL/SSIS packages testing
Answer Question | August 11, 2010 8:43 AM
ETL, SSIS, SSIS Package, SSIS Testing
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
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
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
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
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
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
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
HOW DO I CHANGE THE MaximumErrorCount IN SSIS
Answer Question | May 10, 2011 3:54 PM
SSIS, SSIS MaximumErrorCount, SSIS Package, SSIS Package 2005
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
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
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
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