Viewing 15 posts - 76 through 90 (of 108 total)
Where are the location and product stored?
If it is stored in a table, then you can easily create 400 excel files from a single SSIS package. No need to execute...
March 25, 2015 at 3:42 am
Seems your JOIN is returning multiple records for your single KEY.
Check if there are any duplicates or multiple records present for your KEY.
March 12, 2015 at 1:06 am
Ditto.
Make sure the Odata adaptor is installed, if you are executing your SSIS from a different system.
You can download it from here: http://www.microsoft.com/en-in/download/details.aspx?id=42280
March 12, 2015 at 1:04 am
This is strange.
Can you share a sample package and sample file you are using?
March 3, 2015 at 1:26 am
If you are changing files, you need to refresh metadata in the destination/source.
You are getting errors only because it is not correctly configured and always make sure the destination and...
February 27, 2015 at 4:21 am
You need to give shared folder permissions to the service user which is executing your package from SSISDB.
February 26, 2015 at 9:59 pm
Hi, NO we cannot FTP a file directly.
You need to create it on a UNC path first then you can send it to FTP.
February 26, 2015 at 9:57 pm
Unfortunately I was unable to open your package however I tried executing your files and yes, I succeeded.
I was able to load data in Excel from Sheet1$A3:D6 to write file...
February 26, 2015 at 4:43 am
I have given all permissions, still same issue.
Is there any other way we can store images as binary in SQL table?
February 26, 2015 at 2:35 am
Can you share your sample package and file?
February 25, 2015 at 9:50 pm
muthyala_51 (2/25/2015)
I have an sftp task to download the files from sftp server to local server, once i download all the files to local folder i want to compare to...
February 25, 2015 at 9:48 pm
Use script task in SSIS to check availability of files. Or use two foreach loops.
Then use File system task to copy / move these files to your shared path.
February 24, 2015 at 3:52 am
Lempster (2/24/2015)
anshulparmar (2/23/2015)
No, in case of Excel files, a destination file should be present at the time of loading. SSIS will not create an Excel file dynamically.
That's not correct; it...
February 24, 2015 at 3:04 am
No, in case of Excel files, a destination file should be present at the time of loading. SSIS will not create an Excel file dynamically.
In cases of Excels, generally we...
February 23, 2015 at 11:59 pm
Check your SQL task configuration. In the parameter mapping window please make sure you have below values:
Variable Name: @filename
Direction: Input
Data Type: VARCHAR
Parameter Name: 0
Parameter Size: -1
February 23, 2015 at 11:17 pm
Viewing 15 posts - 76 through 90 (of 108 total)