|
Browse by Tags
All Tags » SSIS ( RSS)
-
|
Today, I took the beta version of the SQL Server 2008 BI certification test , which is free until 7/31. It was pretty grueling. I don't do well with standardized testing but this one was especially lengthy at 70 questions and up to 3 hours to take...
|
-
|
I was recently working with FoxPro for Unix as a data source using ODBC in SSIS (story for another day) and found some interesting scenarios inside of it. We wanted to pull the table name dynamically, thus changing the SELECT statement inside the SSIS...
|
-
|
Due to popular demand, many of the webinars have reached the capacity of more than 1500 registered guests. To make sure everyone could participate, we have added an additional hour each day for those who missed the first session. You must register in...
|
-
|
In this session by SQL Server MVP, Brian Knight, you’ll learn how to make a package that needs zero configuration as you migrate from development to production. He will then show you how to deploy your packages and administer the SSIS service. You’ll...
|
-
|
Nothing gives me more pleasure than teaching and getting the "aha" moment out of a student when the student gets over the learning curve of a potentially difficult product. That feeling on a larger scale is what is exciting me most to announce...
|
-
|
In SSIS, we recently were engaged by a customer who had a fairly simple request. They wished to remove non-numeric items from a column in the data flow. They were doing this in a stored procedure by using a T-SQL replace function row-by-row and we wanted...
|
-
|
One of the most frustrating learning curves for a DBA going to SSIS is the case sensitivity of the environment. Many developers are quite used to this due to option explicit .NET programming languages. The case sensitivity can in some cases create behavior...
|
-
|
Embarrassingly enough, since SQL Server 2005 came out, I've made myself get in the habit of typing localhost instead of (local) because (local) seemed to time out on my laptop. I never really cared enough to research why localhost worked for my server...
|
-
|
File Properties Task This SQL Server 2005 task reads the properties of a file and writes the values to a series of variables. For example, you can use this task to determine if the file is in use (still be uploaded or written to) and then conditionally...
|
-
|
I'm now a huge advocate of using package templates. For more info on how to use them see this post . Template provide a handy way to determine the best practices for your company and reuse those over and over again. Well there's one slight problem...
|
-
|
Even though you can indeed run DTS packages from within SSIS the solution is only partially complete. In Management Studio, you can manage your DTS packages under Managment --> Legacy --> Data Transformation Services. From here, you can open packages...
|
-
|
In case you're looking for SSIS training in the immediately future, I have an upcoming class that we extended to 5 days for the same price. The fifth day includes training in SQL Server 2008 SSIS concepts and additional performance tuning on SSIS...
|
-
|
A Flat File Connection Manager will initially treat each column as a 50 character string by default. Leaving this default behavior will harm you when you go to an integer column into SQL Server or if your column contains more data than 50 characters....
|
-
|
I just got home from SQL Saturday Tampa. Bravo to the organizers (Wes and Pam specifically) and for all the fantastic volunteers. For those who came to my presentation on performance tuning SSIS, you can download the slide deck here: http://pragmaticworks...
|
-
|
When you're creating a flat file, often times you'd like to place a date stamp at the end of the file name in order to show when the file was created simply when sharing the file with a partner. The problem comes in though where you wish to have...
|
More Posts Next page »
|
|
|