Showing posts with label export. Show all posts
Showing posts with label export. Show all posts

Monday, March 19, 2012

How to add SQL statements to the package created by Export Data wizard?

How to add SQl statements to the package created by Export Data wizard? I need to add SQL coming from file, the flow would be like this:

1) SQL would drop all objects: (views, tables, stored procedures) etc

2) SQL would create all objects: (views, tables, stored procedures) etc

3) Export Wizard SSIS package would execute

Also is there a dynamic way to add more tables do the package once created in SQL database? I would like to put the whole task on a scheduler too...

Also can I create all steps automaticly by SQL?|||

RADIOGENERIS wrote:

How to add SQl statements to the package created by Export Data wizard? I need to add SQL coming from file, the flow would be like this:

1) SQL would drop all objects: (views, tables, stored procedures) etc

2) SQL would create all objects: (views, tables, stored procedures) etc

3) Export Wizard SSIS package would execute

Also is there a dynamic way to add more tables do the package once created in SQL database? I would like to put the whole task on a scheduler too...

Execute SQL Task allows you to execute SQL statements. Will that do the job for you?

Yes you can add more tables to the package but you will have to build this yourself. I guess you could use the import/export wizard to create a package for your new tables and then copy whatever it creates into your new package.

To schedule execution of your package use SQL Server Agent.

-Jamie

|||OK, I will add two SQL Controls and see how it goes. I will let you know if there are any problems with this.|||

I heard Microsoft is working on the new Data Transfer tool, which could overcome difficulties I have. Would you know when/if it will become available? Thanks so much.

I am taking those free etraing courses, preatty cool. Seems like 2005 has a lot of new cool features. It would be a shame if I need to downgrade.

|||

Radiogeneris, along with the free etraining, it would help if you spent some time reading Books Online. It's vastly improved from SQL 2000, and has many tutorials and examples that can answer many of the questions you've posted throughout these forums. I can understand your frustration with things being different in SQL 2005, but it takes some work on the user's end as well to learn these features.

|||

I was asking simple questions, some of them are not in the online books (I checked). Like why the controls are greyed out...

Sunday, February 19, 2012

How to access the area beyond the margin?

Hi! I'm new to Crystal Reports but have some projects due very soon!

When I export data from People Soft Query to Crystal, some fields get pushed out to the unworkable area beyond the right margin (beyond the ruler of the Design tab). I cannot select/move/remove these items.

How do I access this "gray" area?

Data is still being retrieved for these fields, so I need to find a way to move or remove them. (Trying to avoid rebuilding all of my new reports!)

Thanks!Did you try setting the landscape print format so that the width will get expanded?|||Did you try setting the landscape print format so that the width will get expanded?

I faced the same problem.. yeah, there are some data in the gray area which i couldnt touch at all.. n yet i try to set it up to landscape in printer properties, but still there are some data missing...

helpppppppppppppp......|||See if you find answer here
http://support.businessobjects.com/