Forum Replies Created

Viewing 15 posts - 451 through 465 (of 13,460 total)

  • RE: execute SSIS package from .bat file

    the executable you want is dtexec.exe. that executable can launch a dtsx package from the  command line, and you do not need to make any modifications to your package.
    mine...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 29, 2017 at 12:41 pm

    #1948810

  • RE: RS.EXE Scripting Issue

    this recent article and the follow up in the forum has a nice code example of getting all reports and all their parameters;
    so you could use this and get...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 29, 2017 at 11:02 am

    #1948791

  • RE: EXCEPT returning matching rows

    excel changes your data to what it thinks is best, it does not 100% maintain actual values.
    does your data have any FLOAT or REAL data types? since those are...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 29, 2017 at 8:05 am

    #1948738

  • RE: Sync data from local db to Central SQL Server

    alladiz - Thursday, June 29, 2017 7:00 AM

    Thanks a lot Lowell for granular level details. I want the SSIS package to reside...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 29, 2017 at 7:09 am

    #1948722

  • RE: Sync data from local db to Central SQL Server

    if the localdb is not sharable, then the local instance has to push data to the central server, instead of the central server pulling from the laptop.

    so an...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 29, 2017 at 6:53 am

    #1948715

  • RE: Sync data from local db to Central SQL Server

    there's a couple of layers to work at here.

    for LocalDB to be accessible to anyone other than the user that created it, it has to be started and...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 29, 2017 at 6:15 am

    #1948710

  • RE: replacing hard coded value with column name fails the query

    jcelko212 32090 - Sunday, June 25, 2017 2:59 PM

    polkadot - Saturday, June 24, 2017 7:32 PM

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 28, 2017 at 2:27 pm

    #1948639

  • RE: Dedup Large Table

    wouldn't it be better to calculate a checksum or binary checksum for the list of columns to test instead?
    the space used would be substantially smaller, right?, then you could...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 28, 2017 at 1:35 pm

    #1948624

  • RE: QUOTED IDENTIFIER ERROR help please

    could it be that some TSQL was pasted into a job step? the ansi settings in a job are NOT the same default settings as when you runt he code...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 27, 2017 at 9:33 am

    #1948410

  • RE: Using File System Task to partially delete directory contents

    if you want to avoid a script task,i would think you could use foreach loop pointing to the directory, with a filter like "MyFile_*.txt"  for the pattern identify the records,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 27, 2017 at 9:26 am

    #1948407

  • RE: Query Taking too long to execute when filter on geography data (STContains,STGeomFromText)???

    id want to see the execution plan and know what indexes are on the table.

    i don't know if the STGeoFromText is slowing things down, if i have the...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 27, 2017 at 6:51 am

    #1948348

  • RE: how to use case with these 2 conditions null and doesnt exist?

    can't you just add another WHEN THEN?

    case 
        when icd.ECCN is not null
      then icd.ECCN
          when sola.ECCN is not null 
      then sola.ECCN 
    else 'missing' end 
    AS TESTVALUEECCN

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 23, 2017 at 12:47 pm

    #1948007

  • RE: Insert multiple of 50 records into tables of headers and rows.

    we need Details. the actual DDL of your current table, a couple of fake sample rows of data, and the DDL of your destination tables.
    with that, we can provide...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 23, 2017 at 6:45 am

    #1947936

  • RE: Insert multiple of 50 records into tables of headers and rows.

    performance wise, SQL server can insert millions of rows in about the same time as a single row or small number of rows,
    so breaking up an operation into multiple...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 23, 2017 at 5:39 am

    #1947917

  • RE: Permission denied error on object

    I've seen  this on a web server due to connection pooling, but it's been a while.
    way back when , we resolved it via two ways: we assigned a default...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 22, 2017 at 7:44 am

    #1947758

Viewing 15 posts - 451 through 465 (of 13,460 total)