Microsoft SQL Server Integration Services (SSIS) is a platform for building enterprise-level data integration and data transformations solutions.
0
votes
0answers
11 views
Custom Task : TaskHost parameters persistence
I am currently developing a custom task and I'm stuck on a problem.
My Custom Task consists of three files:
MBTask that contains the class that implements the interface "Task"
MBTaskUI that ...
0
votes
0answers
15 views
Import and export wizard error in sql server 2008r2
I am getting this error when i am trying to import data from tally erp9.0 using import and export wizard in management studio 2008.
0
votes
1answer
21 views
Use ReportingService API to read custom data source credentials
We have an SQL 2008 R2 server running reporting services and I would like to identify reports that use specific credentials to connect to a data source. In this situation, the reports connect to the ...
-1
votes
0answers
27 views
parameter in SSIS
According to Microsoft document, the type of parameter should be compatible to variable. Surprisingly, each parameter need to set to VARCHAR TYPE when mapping with variable. Otherwise, the task can ...
0
votes
1answer
30 views
Object reference not set to an instance of an object error in SSIS package
I have the following code in a script task but when I try execute the script I get an error with the following message: "Exception has been thrown by the target of an invocation. ---> Object reference ...
0
votes
0answers
19 views
how to create a system generated file layout
Is there anyway to produce a file layout during the export of data from sql-server?
Normally I create manual file layouts, but i'd like to create a system generated layout.
thanks
0
votes
0answers
28 views
SSIS Truncation Failure
I am getting this truncation error and am not sure how to fix it. The length is 4000 in input and output.
Error: 0xC02020C5 at Data Flow Task, Data Conversion [16]: Data conversion failed while ...
2
votes
1answer
28 views
SSIS File System Task fails without error
I am building a simple Integration Services project that reads a "pending" directory of CSV files, loads each one into a staging table, and moves the file to a "completed" or "failed" directory ...
0
votes
0answers
22 views
Unicode character issue in storing XML data into User Variable
I had created a SSIS package in 2005, which will store the XML data generated from Stored Procedure into a XML file. But the unicode character is not shown correctly. ie From the result (XML Data) ...
0
votes
0answers
27 views
Web Service to post the string of xml file
I have a xml file in the string with the soap header and i want to post that to web service. but i am getting a error please help.
public void Main()
{
string strSql;
// Loading the xml ...
0
votes
1answer
40 views
How to process multiple SQL files using SSIS package?
I have number of .sql files which I need to execute them in particular order. How can I do this using SSIS package?
Otherwise, I have to execute these scripts manually in sequence.
1
vote
2answers
27 views
Is it possible to export/import all connections within SSIS?
Does SSIS 2012 allow to export all connections of a project for a further import into another project?
0
votes
1answer
13 views
Is it possible to export/import Project.params within SSIS?
Does SSIS 2012 allow to export settings of a project located into Project.params for a further import into another project?
-1
votes
0answers
7 views
Data from Tally ERp9.0 to SQL Server [closed]
Can some guide me is there any chance to migrate data from tally ERP9.0 to SQL Server 2008. If possible please let me know how. I am very new to SQL Server. I am using SQL Server 2008r2 in windiws ...
1
vote
1answer
17 views
SSIS: Extract the target table of an OLE DB Destination object
I am trying to use the SQL Server SSIS API libraries to determine extac information from all of our packages including the destination tables that are being populated in a OLE DB Destination object.
...
