Hello,
As it has been recomanded to me in this forum I should use "SQL Server Integration Services" to import a sqlServer2000 DB from my webserver. But I can't find this SSIS among the services ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21976187.html
Zones:
MS SQL ServerDate Answered: 09/06/2006 Rating: 9.0 Views: 0
I have created an SSIS package in the BI tool of 2K5&I cant figure out how to schedule it.
I created a job and in job step I do not have the option to select the SSIS as my type .
Thanks ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2304...
I am importing data from a database that only stored the max quantity and used the runtime to build the min quantities for the ranges. An example of the data would be as follows
Min Quantity|Ma...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2340...
Hi
I am trying to fetch the data dynamically in ssis . to get current date as the folder name.
i get folder with name as "06/06/2008"
i declared a variable and used the following date functio...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2346...
I have a situation where we need to read data from multiple source files and merge it all together to form one destination file. Since the existence of any of those flat files can be flaky, we wan...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/Q_23901974.html
Zones:
SSISDate Answered: 11/13/2008 Rating: 8.7 Views: 25
Hi,
I have some queries save in .sql files.
These SQL statements are pretty lengthy in size
Even though they do different things the table names that refer to will change based on the month i ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_24033689.html
Experts,
I'm building an SSIS package that will take a simple two-field flat file and import it into a two-field table. It seems to be bombing in the field mapping. The attached file shows the...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_24071677.html
Zones:
MS SQL ServerDate Answered: 01/21/2009 Rating: 8.8 Views: 0
Experts
I just finished building a simple SSIS package. I'd like to now schedule it to kick off at a certain time each day. How do I turn the package intno an exeutable? I hit "build" and got...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_24072058.html
Zones:
MS SQL ServerDate Answered: 01/21/2009 Rating: 9.3 Views: 0
Hi
I am getting this Error : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. I am using ...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_24085374.html
I am trying to load excel sheet to sql server2005. I converted data types of excel souce to corresponding type of OLEDB Destination.But still I am getting errors.
I enclosed excel sheet ,SSIS Pack...
http://www.experts-exchange.com/Microsoft/Development/Q_24133458.html
Zones:
MS Dev,
SSISDate Answered: 02/17/2009 Rating: 8.6 Views: 31
