SQL Server Integration Services, an ETL tool sold by Microsoft and bundled with SQL Server versions since SQL Server 2005.
1
vote
2answers
163 views
Optimizing SSIS Packages
I have a SSIS package that loads data in an Access DB to tables on a SQL Server DB. Currently I double click the package and excute it. There are times when there is a lot of data to load. My question ...
1
vote
2answers
438 views
Moving data from Oracle to SQL Server : Table size optimization
I am loading data using SSIS from Oracle to an SQL Server database. One table I moved had a size of 4 MB under Oracle but when loaded to SQL Server, the size grows to 7.96 MB!
I analyzed the size ...
1
vote
1answer
550 views
SSIS: “The buffer manager cannot write 8 bytes to file”
We have about 60 or more SSAS cubes on one server. All the cubes have the same structure. Each cube has a different size because each cube has a different underlying data warehouse. However the schema ...
1
vote
3answers
450 views
Encrypt/Decrypt output & input for SSIS task
I use SSIS packages to output the data from one system as Comma Separated Values, and then import that same data into a second system. I have a new requirement to encrypt the CSV text files that are ...
1
vote
2answers
558 views
Using SQL Profiler on SSIS package
Is it possible to use SQL Server Profiler to trace a running SSIS package? I tried to do that, but all I can see in the trace is executing dp_sqlagent_... and the other internal commands! None of the ...
1
vote
1answer
65 views
SQL Data Collector - SSIS required on source server?
For SQL Data Collector:
Do you need SSIS (SQL Server Integration Services) installed on the server that you are collecting data from. Or can the packages be run from another server -- like the one ...
1
vote
1answer
321 views
uninstalling SSRS and SSIS from clustered SQL Server 2008 R2 SP1
Due to the security recommendation, i will need to uninstall the unused SSRS and SSIS component from a production cluster SQL Server 2008 R2 SP1, so what is the caveats and what do I require to do to ...
1
vote
1answer
215 views
How do I handle importing high amounts of transaction data into application DB?
For the moment, this is a hypothetical question. I've got a database that has a high level of transactional data coming into it. I also have a database that supports my website (my application ...
1
vote
1answer
31 views
VLDB with large quantity of data file imports
I am a little out of my league with this scenario and hope this community can help get me on the right direction.
I have recently been tasked with re-designing and implementing a database application ...
1
vote
1answer
250 views
SSIS How can I write to a Specific Cell in an Excel Sheet
I am trying to complete what I thought would be a very simple task but after hours of looking thru various articles and attempting different methods, I still have not been able to Write to a specific ...
1
vote
1answer
43 views
SSIS Suddenly Requires DCOM Permissions
I have recently deployed some SSIS packages. I made a job to run them one after another. However, I am now allowed to use MSDTC. So I chained the jobs together like I have done before, but now I am ...
1
vote
1answer
163 views
How to avoid log space error while executing SSIS packages?
I'm executing ssis package with more than 70 million data's. But I'm facing issue as
log space full error message while executing the package.
Is there any option to resolve this issue?
1
vote
1answer
150 views
error in Execute SQL Task with parameter
I have an Execute SQL Task object in the Error handlers section of a SSIS package. What it does is inserting a record to a table using OLE DB connection. There is a value in the insert statement that ...
1
vote
1answer
144 views
Connect to SQL Server 2012 Database from 2008 Agent Job containing 2008 SSIS Package
I'm planning the rollout of SQL Server 2012. My client has a number of SQL Server Integration Services (SSIS) packages currently deployed to SSIS 2008 and consumed by SQL Server Agent Jobs defined on ...
1
vote
1answer
232 views
SSIS data transfers between two remote servers
Let's say I have three servers, ServerA, ServerB, and ServerC. ServerA has the production database, ServerB has the staging database, and ServerC has the data warehouse. I've created an SSIS package ...
1
vote
2answers
118 views
How do I run a SQL Server 2005 job on Windows 7?
I have Windows 7 and SQL Server 2005 Version 9.00.1399.
I can successfully create an SSIS Package, however I am unable to execute it successfully as a scheduled job. When I run the job, SQL Agent ...
1
vote
1answer
108 views
ssis delete database on error
I'm writing an ssis package that imports a number of access databases nightly. Each database has the potential to have a slightly different schema. Since I'm creating the tables than doing a direct ...
1
vote
1answer
208 views
Sending SQL Server query as CSV via e-mail
Currently I'm using SSIS w/ a hacky solution to get around it not supporting auth on SMTP servers.
Is there a better way I can save a query to a CSV file, then mail it as an attachment?
Thanks
1
vote
1answer
2k views
SSIS Script Component - How to modify the Output0Buffer
I've a script component which accepts records from SQL Azure database table. The script then invokes a web service, which returns the number of failed and success records.
For all the records, I ...
1
vote
2answers
721 views
Flat file manager TextQualifier not working
I've a CSV text file which contains
col1,col2,col3
"abc,cdef",a,b
When I use the Flat File Source and preview the
a
bc,cdef appears on first column.
But when i run and view the result in ...
1
vote
1answer
60 views
How to avoid empty rows in SSIS Excel Destination?
Does anyone have a way to avoid empty rows when using SSIS to export to Excel. Here's a simple example of one data flow task:
OLE DB Source:
Data Conversion (to handle the annoying UNICODE / ...
1
vote
0answers
36 views
Accessing environment variables at design time in SSDT?
I'm re-designing some SSIS packages for 2012 and some parameter/variable/configuration issues are not clear to me.
The result that I am trying to achieve is that the user context's temp folder(stored ...
1
vote
0answers
159 views
SSIS Merge Join Trouble: 3 tables into 1
So I am having trouble merging three tables into one. All sources are DB, and I am using the MERGE JOIN function. When I join my first two tables, using standard left inner join, it returns the exact ...
1
vote
0answers
74 views
Login failed for user sa ssis 2008
I have a problem with ssis2008
I built a package that have a connection with SQL Server authentication (username : sa).
When I use BI, it works fine but when I build a job that used this package it ...
1
vote
1answer
63 views
SQL Server 2012 catalog.executions to sysjobhistory - any way to join them?
I have exhausted my resources and can't find a foolproof way to join the ssisdb.catalog tables to the jobs that run them. Trying to write some custom sprocs to monitor my execution times and rows ...
1
vote
1answer
100 views
Inserting a new lookup value for the SSIS Lookup Transformation
This may be obvious, but I've been banging my head for a while... please point me in the direction of an article if there is one.
I'm importing a series of Excel files into a SQL database.
They will ...
1
vote
2answers
584 views
How to import table's data in MySql from Sql Server?
I am trying to export table from SQL Server 2008 R2 TO MySql 5.5. For this I am using SQL Server Import and Export Wizard of Sql Server 2008, but it is giving this error.
Here this error may be ...
1
vote
0answers
228 views
sql agent job hangs without any errors or warnings
Problem:
we have a SQL Agent job which runs everyday in the morning at 4:00 am. This job hangs sometimes without providing any errors or warnings. It just hangs. BUT when i stop the job and run again ...
1
vote
0answers
82 views
Requesting advice on creating a table controlled SQL job scheduler
I have been tasked with cleaning up a series of SQL jobs that send email updates about various data and system conditions in my company. Currently, there are a ton of jobs, each with its own SQL code ...
1
vote
0answers
237 views
Login failure when running a SSIS package from a SQL Server job
I have a SSIS package that migrates data from a Sybase database to SQL Server. The connection to the source database has been made through an ODBC connection.
If I run the package directly on my ...
1
vote
0answers
89 views
Where can I get information about AcquireConnection call?
I have a dtsx package that fails to run. When I turn on logging I get:
The AcquireConnection method call to the connection manager "MY_DSN" failed with error code 0xC0202009.
MY_DSN is a ...
1
vote
0answers
2k views
Error Authenticating Proxy Account when Executing SSIS job
I have a SQL Server instance that runs 5 scheduled tasks each night, each of which run SSIS packages.
These packages have been running for years and the associated steps run via a Proxy Account ...
1
vote
0answers
145 views
Is there a way to use a SQL Server 2000 database in SSIS 2012?
I just got my first chance to install SQL Server 2012 on a test machine. I also installed all of the management and Visual Studios components. I created a copy of one of my SSIS 2008 packages and ...
0
votes
2answers
581 views
Doing a comparison on two csv files with no Primary Key
I'm wondering if in SSIS there is a way to compare two csv files(with the same structure) with no reference key to make a record unique.
To give you a better picture from what I mean; In initial load ...
0
votes
3answers
393 views
SSIS 2008 painfully slow to import CSV
I am using SSIS to import a 25,000 row CSV to an empty table. The table has a primary key that is populated as the data is inserted. I am using an ADO.Net destination.
What reasons are there why ...
0
votes
1answer
143 views
BI development in Microsoft BI
I need to learn how to create a dimensional modelling for an organisation that do not has a BI tool and BI model.
Where can I learn more about BI development that should be used in a company?
IT's ...
0
votes
1answer
49 views
SSIS Adding column to excel sheet template destination when importing from SQL Table Source
I have an excel sheet template that has 3 columns. I also have a SQL server table that has the same 3 columns plus an additional 4th column. I need to import all 4 columns from the SQL table into the ...
0
votes
3answers
95 views
SQL agent job step's connection managers
Is there any way with T-SQL to list the connection managers that are used in an SQL Agent Job step?
0
votes
2answers
306 views
Advice for ETL from Oracle to SQL Server?
I'm building a data mart in SQL Server which needs to extract each month from an Oracle database. Currently this is done by exporting to flat files, then running all the inserts/updates in SQL ...
0
votes
2answers
36 views
'skip rows' in a flat file source does not work as advertised
In SSIS(2012 specifically) there is an option in the Flat File Datasource to skip a number of lines at the beginning of a file. The preview appears correctly. However, when trying to execute the data ...
0
votes
2answers
114 views
Sync Indexes between two tables
I need to automate and Sync only indexes between two tables ( Primary and Stage_Table) within the same database.
I tried using SSIS SQL Server Objects Task, but looks like it works only when we sync ...
0
votes
2answers
222 views
migrate SQL Server geography data to PostGIS geometry data
I'm trying to use SSIS to transfer point data from a Geography column in SQL Server 2008 R2 to a geometry column in a Greenplum (Postgres 8.2.15) database with PostGIS. I know there's a way to do the ...
0
votes
1answer
1k views
moving data from one db to another using SSIS
I am very new to SSIS and need to work out how to setup a transfer from table A database A to table B database B.
table A contains many more fields than I need in table B, so the process needs SQL ...
0
votes
1answer
158 views
How to load more than one MS-Access-db tables with data in SQL-Server-DB
I'm just getting into SQL-server 2008 R2 ssis, so forgive me if this is a basic question. I'm building an application using integration service.
One of my computer folders contains more than one ...
0
votes
1answer
321 views
SSIS error Property BackupDirectory is not available for Settings
I am trying to edit the SSIS Back Up Database Task And it gives the folowing error
Property BackupDirectory is not available for Settings 'Microsoft.SqlServer.Management.Smo.Settings'. This ...
0
votes
1answer
279 views
Generate a new Sub Plan/Sequence ID in SQL 2005/8 Business Intelligence Development Studio
I have what is effectively a template SSIS package (well a maintenance plan actually) that is copied and used as the basis of new maintenance plans.
In this package there is a Sequence (or a ...
0
votes
2answers
3k views
how to send mail from gmail smtp server by using the ssis [duplicate]
I'm just getting into sql-server SSIS, so forgive me if this is a basic question. Use the SSISwant to send mail from gmail smtp server.
Smtp host =smtp.gmail.com
port=587 ,
...
0
votes
1answer
77 views
SSIS convert DT_WSTR to date
I'm new to SSIS trying to covert data types. I'm pulling data from Google Analytics and loading data into a SQL 2008 database. The date column from Google analytics appears as "DT_WSTR" and the values ...
0
votes
2answers
81 views
Copy data through SSIS package from one machine to another
I have data in few excel sheets which are to be loaded into tables. I've created a few SSIS packages to do this on my local machine.
Now I have to move these tables onto my client's machine, which is ...
0
votes
1answer
139 views
SSIS Raw Data Import Into SQL Server 2008 R2 - Truncation and Condensed Data Type
[Intro]
I have written a two pack SSIS solution to perform a scheduled hourly update of data from multiple tables in a single db (SRC) to single table on another db (TRG).
I get the following errors ...
