Viewing 15 posts - 1 through 15 (of 18 total)
Check whether job owner has access permission to database
Check proxy account
Check 32 bit run option
Check connection configuration is supplied via package configuration or manually passed via expression or...
May 15, 2014 at 1:52 am
Hi,
Use attach db command or Open SSMS and right clich attach database>Select MDF file and clinic OK.
September 17, 2012 at 6:33 am
let us know whether above replace function will help ....because connection manager will accept either cr lf or lf only its mandatory to define beginning itself ...
March 9, 2012 at 9:49 pm
yes you are right. ..if data flow is complicated and another data flow before main data flow and take original flat file and convert to one format ...
March 9, 2012 at 10:33 am
Yes..! You can give going to perticular report item and security.
March 9, 2012 at 9:18 am
Not possible to put tool tip to parameter.
March 9, 2012 at 9:13 am
You can use SSRS Report Viewer in Dot net.
Using SSRS report viewer you call call report server reports or design local reports.
Further you can use dot code to hide/view parameters,pass...
March 9, 2012 at 9:01 am
In my last project I also faced same issue..!
In expression designer of flat file connection manager there is a option for row delimiter and header delimiter which will pick up...
March 9, 2012 at 5:32 am
Ya you are right its not like a SSRS where will give web link to user once its got deployed.
Initially i also expecting same interface of BIDS for end user...
March 9, 2012 at 5:25 am
Use DataFlow task instead of Bulkinsert as posted by rgtft
March 7, 2012 at 4:23 am
Each package protection level change to "DontSaveSensitive". And Use the variable to extract connection string information in connection manager. or use package configuration which stored connection string in SQL Server...
March 7, 2012 at 4:20 am
You need to use Right and Substring function in derived column transformation as suggested by
JasonYousef
March 7, 2012 at 4:16 am
Check out the Data Profiler Task in SSIS for Data issues
March 7, 2012 at 4:12 am
Viewing 15 posts - 1 through 15 (of 18 total)