Random Notes (12 OCT 09)
I started to jot down notes in a notebook – I mean the old school notebook. I have other means to do this digitally but I decided to do it this way to have the feel of real note-taking (Yes, I have a delicious account and I haven’t fully utilized my evernote account). A small composition notebook that I can keep in my pocket and can take wherever I go is just what I need. From time to time, I will share here the “notes” that I have written. I consider these as “technical notes” although most people would consider them junk. I would like to point out that the notes that I record in my notebook may be verbatim of any article. So, please don’t sue me if you see an exact copy of your sentences or paragraphs in these “notes”. I don’t have any particular style or technique of jotting down notes.
- SQL Server 2000 DTS packages that are stored in Visual Basic files cannot be migrated to SSIS 2008
- Dtexec – Command-line utility to execute packages from comman prompt.
- User Accounts needed when viewing, modifying, scheduling, or editing an Integrations Services package:
- User Account of the package owner; or,
- Account with SYSADMIN role on the server on which the package is actually stored
- Shortcut command to the SQL Server Import & Export Wizard (DTS to SSIS) – “dtswizard”
- SQL Server 2000 DTS packages can still run in the SQL Server 2008 environment (legacy mode)
- In the future version of SQL Server, DTS will be deprecated and not supported
- SQL Partition Management – Partitioning Tool. Use case of this tool is found in @sqlfool’s blog
- Microsoft SQL Server Community Samples: Integration Services