Viewing 15 posts - 76 through 90 (of 3,232 total)
The only difference that could happen between running this in SSMS and via SSRS would be in the parameter values. I'd start your troubleshooting efforts there. Make sure...
April 22, 2016 at 2:44 pm
Your seeing a validation warning. You can either add a default value to your variable that you know exists (and then SSIS will validate against it and have it's...
April 21, 2016 at 3:23 pm
This is a pretty simple task if I'm reading your requirements correctly. Before we all do the work for you, can you show us what you've tried and the...
April 21, 2016 at 10:00 am
Good stuff Jeff. I never worked with a DB large enough to really consider partitioning until after 2005 when table partitioning came out and I've worked primarily in Enterprise...
April 21, 2016 at 8:53 am
I've built BI solutions from the ground up for years. One thing I'd like to point out relevant to the previous conversation is that the project I've been on...
April 20, 2016 at 3:51 pm
Yes, I should have been more clear. This will not help w/ the existing delete, it was a suggestion to make the operation much simpler in the future.
April 20, 2016 at 3:35 pm
In addition to what Hugo has stated, you may consider looking into partitioning your table by date (month) if you can. This requires Enterprise Edition, but it would give...
April 20, 2016 at 2:23 pm
If you have a separate data flow for each tab, you don't need to store them in a variable because they don't change. Just add the value (DT_STR,50,1252)"Your Tab...
April 20, 2016 at 8:59 am
I'm confused as to why you need a for each loop to read in one file. You said that you have a new file each day. Where the...
April 20, 2016 at 8:31 am
Dhivya Elan (4/20/2016)
I have recently started using SSIS, and have been exploring various transformations trying to make the best use of them. I currently have a requirement where in,...
April 20, 2016 at 8:00 am
Phil Parkin (4/19/2016)
John Rowan (4/19/2016)
Are you using the .ispac file for deployment?I'm sure you know this, but ispac files get deployed only to SSISDB (as far as I know).
I think...
April 19, 2016 at 12:44 pm
Are you using the .ispac file for deployment?
April 19, 2016 at 12:13 pm
Try out what Scott has suggested. I have not tried it myself, but his theory seems good. I've had to deal with some pretty crazy files over the...
April 15, 2016 at 11:39 am
MERGE would do if you wanted to use TSQL, but if you want to do this in SSIS, you'll need to do one of the following:
1. Use a Lookup Transformation...
April 15, 2016 at 11:33 am
Create a Parameter for your report. On the parameter setup Available Values tab, select 'Specify Values' and add your values in. This will populate the drop down for...
April 14, 2016 at 9:50 am
Viewing 15 posts - 76 through 90 (of 3,232 total)