Viewing 15 posts - 1,036 through 1,050 (of 7,168 total)
As I said earlier, if you want to do this dynamically in SSIS it will require a level beyond basic skills. This can be done in .NET using a Script...
May 30, 2013 at 1:49 pm
A format file is more than just a command line. Its a separate file you have to Create manually.
May 30, 2013 at 1:15 pm
lakshyanda (5/30/2013)
with increase of files the data flow tasks would look messy with individual source -destination...
May 30, 2013 at 12:44 pm
You posted in the SQL 7,2000 Forum but I assume you're on a later version if you're using Database Mail. Please confirm.
If in fact you are using Database Mail I...
May 30, 2013 at 12:07 pm
Windows does not know what to do with a file with a .jar extension by default. You will need to pass the path to the .jar into the JRE using...
May 30, 2013 at 4:45 am
Your plan looks good. You'll need two different Connection Managers, one for your SQL Server and one for your Oracle instance. You could use OLE DB or ADO.NET to talk...
May 29, 2013 at 6:00 pm
sqlfriends (5/28/2013)
Sure. Your package would have a Data Flow containing an OLE DB Source and a Recordset Destination (really it is an ADO.NET DataSet under the covers) to capture the...
May 29, 2013 at 1:02 pm
Great news. There a lot of these connectivity issues but not a lot of solutions that detail renaming a security certificate. It might be extremely helpful to others that find...
May 28, 2013 at 11:32 am
Somewhere in your process you need to define the format of your files, I.e. to specify the metadata of your files. You can do this in SSIS with Flat File...
May 28, 2013 at 9:20 am
Get Sysinternals Process Explorer and see what dtexec has references too when it hangs. It may give some clues as to what might be going on.
May 28, 2013 at 9:13 am
AD supports 15 character computer names so this sounds like a bug in the cmdlet that would have surfaced pretty quick and been fixed, but maybe not. I don't have...
May 28, 2013 at 9:09 am
Ola's solution takes all of that into account. You can have it backup only certain databases, and it supports full, differential and log backups too. Have a look and post...
May 28, 2013 at 9:05 am
Instead of using a cursor directly against sys.databases, try putting the rows into a #temp table first. Also, try adding FAST_FORWARD option to the cursor just to be sure.
If you...
May 28, 2013 at 8:34 am
Could be lots of things. Try some of the basic troubleshooting articles, see if you can narrow it down.
May 27, 2013 at 9:26 pm
What is the difference from your perspective of creating 25 XML format files and creating 25 Source-to-Destination pairs in an SSIS Data Flow? Just curious.
May 27, 2013 at 7:44 am
Viewing 15 posts - 1,036 through 1,050 (of 7,168 total)