Viewing 15 posts - 31 through 45 (of 46 total)
I would look into using pivot and unpibvot functions. You could unpivot the data so you only need to compare 1 column to the string.
Once you compare you can filter...
June 12, 2009 at 1:33 pm
Check this out: http://msdn.microsoft.com/en-us/library/ms345184.aspx
This may seem unrelated at 1st, but give it some thought from an architectural perspective.
If you have an SSIS parent server containing parent packages.
Then several...
June 5, 2009 at 9:48 am
probably makes no difference unless you are having a very finite look at performance, but in either case you need to set validateexternalmetadata to false.
This way SSIS doesn't check...
June 5, 2009 at 9:19 am
haven't added references for scripts within ssis, but I guess that is what you would need to do.
In a normal VS project you would go to the 'references' folder in...
June 5, 2009 at 9:17 am
They aren't really a whole lot more than that.....But...keep in mind that a db's metadata is kept on the [primary] filegroup and you may consider having all user created db...
June 5, 2009 at 8:53 am
to test you may want to convert your datetime to a character field, have a look at it, and begin trying to cast() or convert() the values.
June 5, 2009 at 8:38 am
I think you would want all 4 DataFlow tasks within a sequence container.
Set Sequence Container property 'Transaction Option' to 'Required'. This forces the sequence to initiate a transaction.
For good measure...
June 5, 2009 at 8:28 am
you could also add a script task to your loop to create excel files.
This is a pretty random chunk of code, but it could help you get started.
Imports Microsoft.Office.Interop
Module Module1
...
June 5, 2009 at 7:59 am
also be sure that you set 'validate external metadata' to false for all objects within the dataflow
June 5, 2009 at 7:52 am
ya man....vbscript sendkeys to the rescue.
Here is some vbscript example code to get you started: pop it in a txt file and save it with .vbs extension and run it:
Option...
May 6, 2009 at 1:26 pm
just checking...thats a crappy issue.
Is it really critical to have 05 on the server??
if not then there is 1 obvious solution.
or you may try running dtexec command line util.
There will...
May 6, 2009 at 12:41 pm
I was just confused. Doesn't seem like loading SSMS and opening the db connection in one step is much of a time saver.
I thought maybe you had a pre-configured action...
May 6, 2009 at 12:36 pm
Can I ask why?
why not just schedule an ssis package to do what you want done?
May 5, 2009 at 2:46 pm
In the job agent is your step type ssis?
May 5, 2009 at 2:23 pm
I know this is unlikely, but is there an indexed view or some other db object that the dbo is able to make use of in the execution plan and...
May 5, 2009 at 2:16 pm
Viewing 15 posts - 31 through 45 (of 46 total)