Stack Overflow
Stack Overflow

Questions tagged [ssis-2008]

Microsoft SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration and data transformations solutions. SSIS 2008 is a part of SQL Server 2008 business intelligence platform.

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks.

SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. wikipedia

448 questions
0
votes
0 answers

SSIS: [Excel Source [65]] Error

When I am trying to load data from Excel sheet having 23K rows into SQL Table, I am getting Error [Excel Source [65]] Error: There was an error with Excel Source.Outputs[Excel Source Output].Columns[Proc Description] on Excel …
Umesh
  • 45
  • 1
  • 1
  • 6
0
votes
0 answers

Unexpected result from Powershell script using SSIS

I am executing a Powershell script using a SSIS Process task. The .PS1 code converts .xlsx file to .csv file. The package is running fine in local machine using BIDS, but by using the agent job the package is generating CSV file with…
p2k
  • 2,126
  • 4
  • 23
  • 39
0
votes
0 answers

redirect the records to different folder if the format is incorrect using SSIS

i have created the SSIS package to load the comma delimited flat file data into the Sql server destination table.To Achieve this i have used Data flow task, flat file source and ole db destination.I have configured the flat file connection manager…
user255826
  • 41
  • 8
0
votes
2 answers

SSIS dynamic Excel destination not working

I created a simple SSIS package to output an SQL table into an Excel file. I gave the dynamic name to the Excel connection manager using the expressions and set the Delay validation to TRUE on entire package, Data Flow and Excel connection…
TERISHKA REDDY
  • 1
  • 1
  • 5
0
votes
3 answers

The type of the value being assigned to variable differs from the current variable type

My SSIS package fails with the error: The type of the value being assigned to variable differs from the current variable type. I declared a variable of type string and corresponding column name in SQL table is varchar(33). If I use data type as…
RMu
  • 817
  • 2
  • 17
  • 41
0
votes
1 answer

SSIS 2008 Script Component Update record

I am trying to move data from one database to another and need to do some massaging of the data in a script component. The thing is that, though I can declare all the fields in the component, it seems rather counter to the nature of SSIS to do…
10thTiger
  • 95
  • 2
  • 10
0
votes
0 answers

ssis OLEDB Source connection manager

My source Database is getting restored every 15 mins. When I tried to load the data from source DB, it is kicking me out, hence my package is failing. Is there anyway in SSIS to wait for source DB connection to come back and start the extraction…
mls1984
  • 29
  • 3
0
votes
0 answers

Get stored SSIS Package's Connection string information

I have 100s of packages in my current production server. I have to check the server and DB details of all these stored SSIS packages. The packages are available under Server>Stored Packages>File System. The manual way is to download each package and…
p2k
  • 2,126
  • 4
  • 23
  • 39
0
votes
2 answers

Determining when a SSIS 2008 package was deployed on a server

I want to find when an SSIS 2008 package was deployed under MSDB in an instance of SQL Server. In the table dbo.sysssispackages, I can see package creation date but where can I find the last modified/deployed date of a package?
RMu
  • 817
  • 2
  • 17
  • 41
0
votes
1 answer

Provider string setting in SSIS config file on SQL Server 2008 R2

I've inherited an SQL Server 2008 R2 environment running on Windows Server 2003. I do not know if it was upgraded from SQL Server 2005 or if it was a freshly built out system. Due to issues with not being able to virutalize the physical server, it…
Monkeydaddy
  • 1
  • 1
0
votes
0 answers

Split CSV file based on first column value changes and load into destination table in SSIS?

I have Import.csv file, First column values --> table names which are already exists in target database. Next two columns [Desc],[Code] data gets populate from CSV file to table. TABLE_NAME DESC CODE tab1 table1 A tab1 table1 …
ScriptGuy
  • 101
  • 3
  • 12
0
votes
0 answers

Best way to refine data in ssis

I am having a text file with millions of records and have to extract and update to some staging table. Now the problem is we don't have any text qualifier to the separate columns from others. My column delimeter is "," and I am having some fields…
Sarat
  • 176
  • 7
0
votes
1 answer

SSIS Package OLEDB Source Timeout property is not working

I am trying to use timeout property on OLEDB Source in SSIS package, i set timeout property to 60 seconds and i know my source query takes 1 hour to finish. After setting timeout property i executed the package but package/OLEDB source didn't…
VInayK
  • 1,501
  • 6
  • 34
  • 47
0
votes
0 answers

change tablename dynamically for Data flow task

I need to do a loop over comany names using ssis What I did Declare a SSIS variable of Object type. Through a SQL task execute a query ("select distinct Name from dbo.company") & - fill you variable in result set. Apply a For Each Loop. In the…
canada canada
  • 1
0
votes
1 answer

SSIS loop over companies

I have a package SSIS for a company . Now I need to repeat the same work for 30 companies . Company name [Montreal$G_L_ entry] [Dubai$G_L_ entry] I would like like to loop over all companies . I get all the company names and put them in an ado…
test canada
  • 3
  • 1
1 2 3
…
29 30